Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 136
Default Flushing Memory/Cache Clear:

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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 35,218
Default Flushing Memory/Cache Clear:

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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6,953
Default Flushing Memory/Cache Clear:

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to clear clipboard memory? Eric Excel Discussion (Misc queries) 2 April 6th 10 06:09 PM
How to Clear a Pivot Table Cache DoctorG Excel Discussion (Misc queries) 1 February 16th 10 03:04 PM
Memory/Cache Clear: Ardy Excel Programming 3 July 19th 07 03:42 PM
MSXML2.XMLHTTP clear excel cache/memory (?) p3plyr Excel Programming 3 March 21st 07 10:15 AM
Pivot Cache Memory Jared Excel Programming 0 December 16th 04 04:31 PM


All times are GMT +1. The time now is 06:41 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"