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
&oWorkApp.ActiveWorkbook.SaveAs("c:\temp\file.xls");
As soon as I add another parameter like below
&oWorkApp.ActiveWorkbook.SaveAs("c:\temp\file.xls",xlworkbooknormal);
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.
Thanks Again
Tags:
© 2024 Created by Maisam Agha.
Powered by