0
06221968
I have automation code running from Access that works in both Windows 98 and
in Office 2002, but generates a run-time error in 2003. Assuming all
variables are declared and the EXCEL spreadsheet is open (which was validated
via debug.print commands), the following line generates the error,
"Automation Error: Server Threw an Exception".
Set NewSheet = xlNewBook.Worksheets.Add
This has been very frustrating and the client does not understand why I
cannot solve the problem. I am at a total loss. Any help???
in Office 2002, but generates a run-time error in 2003. Assuming all
variables are declared and the EXCEL spreadsheet is open (which was validated
via debug.print commands), the following line generates the error,
"Automation Error: Server Threw an Exception".
Set NewSheet = xlNewBook.Worksheets.Add
This has been very frustrating and the client does not understand why I
cannot solve the problem. I am at a total loss. Any help???