View Single Post
  #3   Report Post  
Dave Peterson
 
Posts: n/a
Default

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