Workbook SaveAs method fails
Posted: Wed Nov 25, 2009 4:41 pm
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
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