How to compact an Excel file with VBA
 

Hello:

Each time I write the smallest of VBA codes, the size of
my excel file baloons? Any ideas why? Any thoughts on how
to compact the file?

Your help is appreciated.
-Neil

How to compact an Excel file with VBA
 

maybe you should try using Rob Bovey's codecleaner program.

You can find it at:
http://www.appspro.com/

It exports, deletes, imports the modules.

Neil Bhandar wrote:

Hello:

Each time I write the smallest of VBA codes, the size of
my excel file baloons? Any ideas why? Any thoughts on how
to compact the file?

Your help is appreciated.
-Neil

--

Dave Peterson