Hi
I have an Excel file that is quite large and has to be saved across a network. It has been set up so that a user just has to press a button and it is saved. Is it possible to save it has a zip file and then save that file across the network from vba? That will then reduce the size of the file by about a fifth and consequently work better
Cheers
Peter

It used to be the case that if you had WinZip you could also download a version that could run from command line, not sure if you still can though. You could also search for "zip command line" on Google. Then you can use the Shell command:

Shell "Zipper.exe <pathToExcelFile> <nameOfOutputDocument>"

--

Joe

A quick test using WinZip on my machine indicates that you can't ZIP a file that is currently open.