How to compact an Excel file with VBA

[Neil Bhandar]

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]

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.