vba excel

[murugavelmsc]

Hi all,

I create a macro in excel through vba of file size of 3 MB, when i run the script and save it as an different file name means , that file have a size of same 3 MB.
How to solve the issue.

Please help me.

Thanks,
Murugavel

[Stewart Ross]

Open a new, blank, Excel workbook. Create a new code module for that workbook, then copy the VBA code for your macro from the over-large file into the new module. Save your new file.

Excel files tend not to shrink if they've grown in size, even if you delete all the contents and formatting of the original file before you store it again.

-Stewart