Automation Error - EXCEL 2003

[Guest]

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???

 

[Dave Patrick]

One of these may help.

http://support.microsoft.com/kb/q238986/
http://support.microsoft.com/kb/177300/EN-US/
http://support.microsoft.com/kb/q186063/
http://support.microsoft.com/default.aspx?scid=kb;EN-US;316731&fr=1
http://support.microsoft.com/default.aspx?scid=kb;EN-US;327667&fr=1

--
Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

:
|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???