access query/excel.exe problem

[JKC]

I import data into Excel using a VBA macro and an Access query. This
works fine, the problem is that the Excel application is still using
way too much memory after the query is done. All calculations are
finished, but the whole system is bogged down by excel.exe. Even if I
close excel after the query has run, excel.exe is still running in the
background. Does anyone have any idea how to fix this. Thanks

 

[shockley]

Sounds like you have two instances of excel running before you close excel.
Use Task Manager (Ctrl-Alt-Del), the Processes tab, before you close Excel
to see if there are two instances of excel in the list. What OS are you
using?

 

[JKC]

shockley Posts: n/a

Re: access query/excel.exe problem

--------------------------------------------------------------------------------

Sounds like you have two instances of excel running before you close
excel.
Use Task Manager (Ctrl-Alt-Del), the Processes tab, before you close
Excel
to see if there are two instances of excel in the list. What OS are
you
using?


I'm using XP. I have checked this and there is only one running. It
Just seems very strange because I've been running this type of macro
for years. Thanks