Code doesn't disappear

[Otto Moehrbach]

Excel XP & Win XP
I've never seen this before but I can't say it has never happened
before.
I have wb A.xls open and I work in the VBE.
I get finished and CLOSE THE WB but leave Excel running.
I go into the VBE and, behold, there is wb A.xls listed.
I click on wb A.xls and there is the code for that wb. All of it.
Remember that wb A.xls is closed.
Is this normal? Thanks for your time. Otto

 

[Susan]

as far as i am aware, the VBE doesn't get cleared until excel gets
completely closed out. therefore, whatever documents you open in a
session of excel remain in the VBE until you close excel.

susan

 

[Susan]

well, now, i may be completely wrong on that.
it doesn't work that way on my machine (at the moment) although i know
i have seen lingering documents in the VBE before..........
susan

 

[Tim Zych]

I believe this is normal as A.xls is still in memory.

This is replicable:

1. Create a workbook called A.xls. Add a module with some code.

2. Create a 2nd workbook, add a module and run the following macro:

Public wkb As Workbook
Sub Test()
Set wkb = Workbooks("A.xls")
End Sub

3. Close A.xls

4. Go back to the VBE and A.xls is still there and the code is visible too.

5. Click the Stop button. A.xls is cleared out.

Now perform the steps again with a modified macro, and omit Step 5.

Sub Test()
Set wkb = Workbooks("A.xls")
Set wkb = Nothing
End Sub

A.xls is no longer available.

 

[ryguy7272]

Excel must be loaded in your system memory. If you hit Ctrl+Alt+Delete and
click 'Task Manager', do you any instances of Excel under the 'Processes' tab?

Maybe just before you exit the A.xls book you need to include something like
this:
http://www.tek-tips.com/viewthread.cfm?qid=923847&page=1

In the ThisWorkbook Object put a small snippet of code like this:
Private Sub Workbook_BeforeClose(Cancel As Boolean)
Call 'YourCloseMacroNameHere...see example in link above
End Sub


HTH,
Ryan---