Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello All:
I have a general question, It seem that when I run some codes, doesn't matter what it is, Once I modify it in the same session, it seem that the previous version to the modification is still in the memory. I suspected this so to confirm it I have added letters to the given messages and I still get the previous message, it almost seems that the original code is stuck in the memory. If this assumption is correct how would I flush memory. What are the pro and cons of such action. ____________ Sample _____________ If Some code Then Do something Else MsgBox "Message!" Exit Sub The code to flush memory End If |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
You have a guess at your first post.
Ardy wrote: Hello All: I have a general question, It seem that when I run some codes, doesn't matter what it is, Once I modify it in the same session, it seem that the previous version to the modification is still in the memory. I suspected this so to confirm it I have added letters to the given messages and I still get the previous message, it almost seems that the original code is stuck in the memory. If this assumption is correct how would I flush memory. What are the pro and cons of such action. ____________ Sample _____________ If Some code Then Do something Else MsgBox "Message!" Exit Sub The code to flush memory End If -- Dave Peterson |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Change the code enough so that you can do Debug and then "Compile Project
name" is not greyed out. Then Compile the project. -- Regards, Tom Ogilvy "Ardy" wrote: Hello All: I have a general question, It seem that when I run some codes, doesn't matter what it is, Once I modify it in the same session, it seem that the previous version to the modification is still in the memory. I suspected this so to confirm it I have added letters to the given messages and I still get the previous message, it almost seems that the original code is stuck in the memory. If this assumption is correct how would I flush memory. What are the pro and cons of such action. ____________ Sample _____________ If Some code Then Do something Else MsgBox "Message!" Exit Sub The code to flush memory End If |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to clear clipboard memory? | Excel Discussion (Misc queries) | |||
How to Clear a Pivot Table Cache | Excel Discussion (Misc queries) | |||
Memory/Cache Clear: | Excel Programming | |||
MSXML2.XMLHTTP clear excel cache/memory (?) | Excel Programming | |||
Pivot Cache Memory | Excel Programming |