How to get Excel XP out of memory?

[gdev]

Hi,
Please help.
While importing an Excel spreadsheet to Access, I am using:
xlapp.workbooks close
xlapp.quit
set xlapp = nothing.
Yet Excel stays in memory.
I attempted to use xlapp.workbooks.close (false), but received an error message.

Please assist.

Thanks Gwen

 

[PHV]

How are you importing the Excel spreadsheet to Access ?
Seems your code use implicit instantiation of the Excel.Application object like, eg, ActiveSheet instead of xlapp.ActiveSheet ...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[TonyJollans]

Hi gdev,

I echo PHV's question - how are you doing the import?

Also, how do you know Excel stays in memory? Is it because it remains visible? In other words is it failing to close workbooks and/or quit? or is it apparently working but still showing in the task list?

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.
Excel VBA Training and more Help at [url=http://www.vbaexpress.