VBAProject remains open after file is closed

S

sequoia sam

Although I close my files with Excel, they remain visible as objects in
the VBAProject Manager window.

This is a problem because I open and close a lot of files, and this
generates a lot of objects in this window, including duplicate objects
when I have opened and closed a file multiple times. I'm also
concerned that the open objects my be using system resources.

How do i clean up this objects?

Thanks very much.
 
J

Jim Rech

This is a long time problem. Unfortunately, I have never heard of a way to
get the VBE back in sync.

--
Jim
"sequoia sam" <[email protected]>
wrote in message
|
| Although I close my files with Excel, they remain visible as objects in
| the VBAProject Manager window.
|
| This is a problem because I open and close a lot of files, and this
| generates a lot of objects in this window, including duplicate objects
| when I have opened and closed a file multiple times. I'm also
| concerned that the open objects my be using system resources.
|
| How do i clean up this objects?
|
| Thanks very much.
|
|
| --
| sequoia sam
| ------------------------------------------------------------------------
| sequoia sam's Profile:
http://www.excelforum.com/member.php?action=getinfo&userid=25782
| View this thread: http://www.excelforum.com/showthread.php?threadid=391866
|
 
D

Dave Peterson

Close excel and reopen?

(I've seen this, but I've never seen it cause a problem--maybe just as an
irritant.)
 
S

sequoia sam

thanks for you comments and suggestions
I am really amazed that this is "normal" behavior. Somehow, I expect
that it is related to Windows. I have a feeling this would not happen
on a Mac.

I tried closing files one by one to see if the VBAobjects would
disappear. They don't, even after I closed all files (but kept the
Excel App open).

Interestingly, the code for modules still appears when I click on any
of the VB modules in the "closed" files. So this problem must be using
memory.

Maybe I need a memory clean-up tool? Any suggestions would be
appreciated.

Thanks.

sequoia sam
 
D

Dave Peterson

I don't think it's normal behavior--it doesn't happen all the time.

But I don't have any other suggestions besides closing excel and reopening it.
 
Top