Size matters, or Brother can you spare a Mega-Bite
Posted by Tom Urtis on June 23, 2001 1:42 AM
Sometimes I wonder if VBA stands for Very Big Application.
My concern is inexplicable file size, which I know has been discussed here before but I still don't understand how some files manage to get so huge.
Tonite I finished a VBA-filled template that is 700 KB in size, to automate a here-to-fore manually generated report that was typically 1 MG. Instead of being a 1.7 MG end product, the thing is almost 6 MGs.
Is there something in the VBA water that causes this? Any tips on keeping file size down? I did everything I could think of already (no formulas in unused ranges, limited formatting, etc).
Thanks for any ideas.