Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automation Error
I'm converting an Access 97 app to Access 2K3. One routine uses
Access to create, load and save an Excel workbook. I'm getting the automation error message "The server threw an exception" when Access 2K3 tries to save the workbook, using MyWorkbook.SaveAs Filename:="drive:\path\filename.xls". When I step through all the code filling up the spreadsheet, there are no problems at all until I get to the saveas command. Can anyone shed any light on this? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automation Error
I had a similar problem and I was able to get around it using SaveAs, instead
"Peter L Reader" wrote: I'm converting an Access 97 app to Access 2K3. One routine uses Access to create, load and save an Excel workbook. I'm getting the automation error message "The server threw an exception" when Access 2K3 tries to save the workbook, using MyWorkbook.SaveAs Filename:="drive:\path\filename.xls". When I step through all the code filling up the spreadsheet, there are no problems at all until I get to the saveas command. Can anyone shed any light on this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automation Error | Excel Discussion (Misc queries) | |||
Automation Error | Excel Programming | |||
RunTime Error (Automation Error) | Excel Programming | |||
Automation Error, Unknown Error. Error value - 440 | Excel Programming | |||
Unknown where is the problem on the Runtime error - Automation error | Excel Programming |