View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones[_2_] Norman Jones[_2_] is offline
external usenet poster
 
Posts: 421
Default Can we zip a file using macro.

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



---
Regards.
Norman


"Arvind Mahto" <Arvind wrote in message
...
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.