Can we zip a file using macro.
 

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.

Can we zip a file using macro.
 

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

HTH,
Matthew Pfluger

"Arvind Mahto" wrote:

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.

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.