Code doesn't disappear
 

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

Code doesn't disappear
 

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


On Mar 24, 2:30*pm, "Otto Moehrbach"
wrote:
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

Code doesn't disappear
 

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


On Mar 24, 2:40*pm, Susan wrote:
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

On Mar 24, 2:30*pm, "Otto Moehrbach"
wrote:



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- Hide quoted text -

- Show quoted text -

Code doesn't disappear
 

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.


--
Tim Zych
http://www.higherdata.com
Workbook Compare - Excel data comparison utility
Free and Pro versions

"Otto Moehrbach" wrote in message
...
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

Code doesn't disappear
 

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.c...=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---