VBAProject remains open after file is closed
 

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...o&userid=25782
View this thread: http://www.excelforum.com/showthread...hreadid=391866

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

--
Jim
"sequoia sam"
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...o&userid=25782
| View this thread: http://www.excelforum.com/showthread...hreadid=391866
|

Close excel and reopen?

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

sequoia sam wrote:

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...o&userid=25782
View this thread: http://www.excelforum.com/showthread...hreadid=391866

--

Dave Peterson

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


--
sequoia sam
------------------------------------------------------------------------
sequoia sam's Profile: http://www.excelforum.com/member.php...o&userid=25782
View this thread: http://www.excelforum.com/showthread...hreadid=391866

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.

sequoia sam wrote:

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

--
sequoia sam
------------------------------------------------------------------------
sequoia sam's Profile: http://www.excelforum.com/member.php...o&userid=25782
View this thread: http://www.excelforum.com/showthread...hreadid=391866

--

Dave Peterson