#1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 10,593
Default Cleaning Up

Code does bloat a file.

Try using Rob Bovey's Code Cleaner periodically,
http://www.appspro.com/Utilities/CodeCleaner.htm

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Rocks" wrote in message
...
Hello,
I recently was able to recover my Excel VBA Module from a corrupted Excel
File using OpenOffice Calc Application. After saving it back to an Excel
File I went back in and found every part of the File intact. I did notice
though that the size of the file was reduced in half, from 5.6 meg to 2.8

meg.
My question is,
Did my Code while running create all the extra size?
Is there a piece of code that I can append to the end of my program to

clean
up before exiting?

Thanks,
--
Rocks



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
Cleaning data Torero Excel Worksheet Functions 3 November 28th 06 10:16 PM
Cleaning Data AMMark Excel Discussion (Misc queries) 1 October 19th 06 07:21 PM
Cleaning Up Data [email protected] Excel Discussion (Misc queries) 3 September 20th 06 04:40 PM
Cleaning up some VB Ton Taetsch Excel Programming 1 November 16th 04 12:53 AM
Help cleaning up some Strings 43N79W Excel Programming 6 September 4th 04 01:04 PM


All times are GMT +1. The time now is 02:55 AM.

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

About Us

"It's about Microsoft Excel"