Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #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
Reply
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
Which workbook is stuck in memory Tod[_3_] Excel Programming 1 February 9th 04 09:57 PM
Closed workbook remains in memory. Kent Prokopy[_3_] Excel Programming 6 December 4th 03 01:37 PM


All times are GMT +1. The time now is 02:26 PM.

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"