PC Review


Reply
Thread Tools Rate Thread

clearing excel memory before saving

 
 
Warren
Guest
Posts: n/a
 
      20th Jul 2008
Excel seems to hold onto its completed macro in the background. then saving
the file increases file size by 4.5 mb.

Can you code in a macro to run, then clear its memory. User can then save
file when ready without increasing the file size. The information only
sorts, no new data is added, but file increase 4.5 mb. You can run the marco
as many times as you like, file size does not continue to grow.

You can exit, reopen and re save and the file decrease by 4.5mb until the
marco is re run.

Many thanks if you can help - going mad trying to work it out

code im using is below

Code

Sheets("Team Data").Select
Range("A5:BK300").Select
Selection.Sort Key1:=Range("A5"), Order1:=xlAscending, Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom
Range("A5").Select
Sheets("Input").Select
Range("C5:GF300").Select
Selection.Sort Key1:=Range("FI5"), Order1:=xlAscending, Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2007 - system you are saving does not have enough memory Ben Jitima Microsoft Excel Discussion 3 16th Feb 2011 05:52 PM
Saving Excel file locks up all memory resources, accesses externalfile? benscordell@gmail.com Microsoft Excel Misc 4 21st Dec 2007 11:01 PM
Clearing Memory Pete-Peters@sbcglobal.net Microsoft Excel Programming 2 16th Mar 2006 02:20 PM
Memory could not be read when Saving Excel using a macro duncansant Microsoft Excel Crashes 0 19th Aug 2005 01:10 PM
Excel Memory Saving Issues Robert McGonnell Microsoft Excel Misc 1 24th Oct 2003 10:59 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:05 PM.