Can we zip a file using macro.

[Arvind Mahto]

Hi, All,
I am on a project where i want to zip an excel fil using macro. Is it
possible. If yes, please let me knoe the coding.

Your suggestion would be very valuable for me.

 

[Matthew Pfluger]

Ivan Moala has a script that zips and emails files. Perhaps you can use part
of that code. Find it here:
http://www.xcelfiles.com/Outlook_02.html

HTH,
Matthew Pfluger

 

[Norman Jones]

Hi Arvind,

See Ron de Bruin at:

Zip Activeworkbook, File or Files with WinZip (VBA)
http://www.rondebruin.nl/zip.htm

See also:

Zip file or files with the default Windows XP zip program (VBA)
http://www.rondebruin.nl/windowsxpzip.htm