Page 1 of 1

Workbook SaveAs method fails

Posted: Wed Nov 25, 2009 4:41 pm
by stevek
Can anyone advise cause of following problem when trying to save an Excel workbook.

I have created an excel workbook in jade and populated all data.

Final step is to
workbook := theExcelApp.activeWorkbook;
workbook.saveAs(theFileName,
null, null, null,
null,
null, null, null,
null, null, null);

However this results in an activeX error of -2146827284 when the SaveAs line is executed.
I have researched the error code on the web and cannot find any reason that relates to my problem

Re: Workbook SaveAs method fails

Posted: Thu Nov 26, 2009 11:07 am
by stevek
Please ignore query.
Discovered after I rebooted the client machine, everything worked as expected.
:!: :!: