As posted, the code appears to be correct. The problem most likely exists in
the unposted code.
The most usual cause of the Excel app not closing is an incorrect or
incomplete object reference. When using Automation it is critical to fully
qualify all your object references. If Access can't determine an Automation
ojbect reference, it will create another Excel Application object on its own
and use that. So when you Quit, you quit one, but not the other.
Check all your object references to be sure every object created refers all
the way back to the original Excel Application object.

Signature
Dave Hargis, Microsoft Access MVP
> I have the following code in Access that is used to open an Excel file, do
> some work with that file, then close the file and the Excel application.
[quoted text clipped - 25 lines]
>
> Thanks.
Martin - 29 Apr 2008 16:09 GMT
Thanks for the reply. I will dig back thru the references.
> As posted, the code appears to be correct. The problem most likely exists in
> the unposted code.
[quoted text clipped - 37 lines]
> >
> > Thanks.