Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
access query/excel.exe problem
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 -- JKC ------------------------------------------------------------------------ JKC's Profile: http://www.excelforum.com/member.php...o&userid=31166 View this thread: http://www.excelforum.com/showthread...hreadid=511212 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
access query/excel.exe problem
shockley Posts: n/a 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 -- JKC ------------------------------------------------------------------------ JKC's Profile: http://www.excelforum.com/member.php...o&userid=31166 View this thread: http://www.excelforum.com/showthread...hreadid=511212 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 Query Wizard problem with Access 2007 extensions | Excel Discussion (Misc queries) | |||
Vlookup problem with Access Query import into Excel 2000 | New Users to Excel | |||
Problem doing Query to Access with Excel sheet protected | Excel Programming | |||
Problem with VBA code trying to query and access database | Excel Programming | |||
Problem with excel linking to Access query | Excel Programming |