PeopleSoft Community Network
I am stumped with an issue. Thanks in advance for any helpful replies.
Using OLE from a peoplesoft application I am trying to open up excel, edit the document and save it as a shared workbook. Everything works fine until I add any paramater other than the filename to the "saveas" command.
For example this works without any problem
As soon as I add another parameter like below
I get an error "OLE Automation error in _Workbook.SaveAs: ObjectDoMethod: Unable to get the SaveAs property of the Workbook class. "
The end result is I want to be able to make the workbook shared so will glady consider other options to achieve that result.
it's a pleasure to meet you. I am USA Army personnel, i have an important thing to discus with you.
Please write me on my email (email@example.com)