Reducing Excel File Size

[lesoies]

Currently using Excel 2010 and also have Winzip installed on my computer. One "trick" I have learned to reduce Excel file size is to use Windows File Explorer to change the Excel file extension to a zip extension (xlsx to zip) and then "unzip" that file to a unique folder, as xlsx files are basically zip files of xlm files. After unzipping, I then re-zip the files using the Winzip program, and then rename the zip extension to xlsx, which opens fine in Excel. This process reduces the file size ~25%.

I was wondering if there is an Exel macro that can do the process above? The path to Winzip on my computer is C:\Program Files\WinZip\WINZIP64.EXE. However, I have another comptuer where the path is C:\Program Files\WinZip\WINZIP32.EXE, so it would need to take into account those two locations.

I know there are other technqiues to reduce file size, but this seems to work the best Thanks.

[FDibbins]

I have never seen or heard of reducing file size that way, but if it works for you, thats great.

alternative ways to reduce file size (and reduce calc time) is to remove any unused columns and rows in you're sheets. use end/home, and if that takes you past the last used row/column, delete those extra rows/columns.
also, reduce/eliminate as far as possible any array formulas, and change any formulas that reference entire rows/columns (A:A, 1:1) to only the range they need to apply to