[AccessD] Automation of Excel through Access Problem

Gustav Brock gustav at cactus.dk
Tue Jun 15 13:06:33 CDT 2004


Hi Jeffrey

Then something else must be going on.
Listen to Jim; I missed that your code runs the first time.

Try changing these:

2050  excelApp.Quit
2060  Set excelFile = Nothing
2070  Set excelApp = Nothing

to:

2049  Set excelFile = Nothing
2050  excelApp.Quit
2070  Set excelApp = Nothing

Also, check Task Manager if a "hidden" Excel is running.
/gustav


> Did not work.  I am still getting the same message (which I did not include
> in my first post):

> Run-time error '1004' Method 'Range' of object '_Global' failed.




More information about the AccessD mailing list