I have two Excel/Macro files that are almost identical in content (sheets, modules, code etc) but very different in size. One is 815KB, the second is 1490KB.
Can anyone tell me some factors that may influence the size of macro/Excel files. I know that with VB exe files they can grow with use and sometimes need to be recompiled to make them smaller.
Is this a similar thing with Excel/Macro files? Are there any other reasons files may grow with use? Other than the forms, sheets and modules could there be other reasons one file is so much bigger than the other?
Any ideas orsuggestions would be greatly appreciated
Thanks
voodoo
Can anyone tell me some factors that may influence the size of macro/Excel files. I know that with VB exe files they can grow with use and sometimes need to be recompiled to make them smaller.
Is this a similar thing with Excel/Macro files? Are there any other reasons files may grow with use? Other than the forms, sheets and modules could there be other reasons one file is so much bigger than the other?
Any ideas orsuggestions would be greatly appreciated
Thanks
voodoo