How do i zip up a file in Excel using VBA for Excel?

[MarkGarside]

Hi there,

I'm stuck trying to zip up a file in Excel using WinZip, with VBA. Really it is just to do a backup of the file each time the file is modified, while not taking up mucj memory. Any help would be gratefully received.

Cheers

Mark

 

[ETID]

Look on the winzip web site for a free utility called WZZIP.exe it will allow you to use the shell command to run winzip processes.