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

Views: 251

Reply to This

Replies to This Discussion

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 (captkristen899@gmail.com)

RSS

PeopleSoft Jobs in US

Videos

  • Add Videos
  • View All

© 2024   Created by Maisam Agha.   Powered by

Badges  |  Report an Issue  |  Terms of Service