LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 17
Default Which workbook is stuck in memory

I have several workbooks that are updated overnight, using
vbscript to open the workbook and run its code, then close
the workbook. The workbooks are updating just fine, but
there is always a copy of Excel left open in memory. I
have to go into Task Manager each day and kill it from
there. I've used error handing and log files and such to
try to get these workbooks to tell me what they don't
like, but no errors are occuring. I've also made sure that
my vbscripts all contain code to quit the Excel
application.

Is there a way I can find out which workbook caused the
Excel App to be left open in memory?

tod
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
XL 2007 - Out of Memory - memory leak/bug? PCLIVE Excel Discussion (Misc queries) 0 March 23rd 09 03:31 PM
Users stuck, not logging out of shared workbook Peter Excel Discussion (Misc queries) 1 January 4th 07 02:01 PM
Moving workbook to memory stick - hyperlinks fail Brucear Excel Discussion (Misc queries) 2 September 18th 06 12:32 AM
Closed workbook remains in memory. Kent Prokopy[_3_] Excel Programming 6 December 4th 03 01:37 PM
The instruction at "0x65255ac9" referenced memory at "0x00000008". The memory could not be read. Clikc OK to terminate etc Angus Comber[_2_] Excel Programming 1 November 7th 03 01:18 PM


All times are GMT +1. The time now is 11:20 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"