Call external program in Excel Macro
 

Dear all,

I have to write a macro which can call an external program, say "Winzip", to
zip some specific files. Can anyone advise how to do it??
Thanks a million in advance!

Ivan

Call external program in Excel Macro
 

Hi Ivan,

See the Shell function in VBA help.


---
Regards,
Norman


"Ivan" wrote in message
...
Dear all,

I have to write a macro which can call an external program, say "Winzip",
to
zip some specific files. Can anyone advise how to do it??
Thanks a million in advance!

Ivan

Call external program in Excel Macro
 

Hi Ivan,

You might also wish to visit Ron de Bruin's Zip page at:

http://www.rondebruin.nl/zip.htm


---
Regards,
Norman



"Ivan" wrote in message
...
Dear all,

I have to write a macro which can call an external program, say "Winzip",
to
zip some specific files. Can anyone advise how to do it??
Thanks a million in advance!

Ivan

Call external program in Excel Macro
 

Hi Norman,

Your help is so helpful. Thanks a million!

Ivan

"Norman Jones" wrote:

Hi Ivan,

You might also wish to visit Ron de Bruin's Zip page at:

http://www.rondebruin.nl/zip.htm


---
Regards,
Norman



"Ivan" wrote in message
...
Dear all,

I have to write a macro which can call an external program, say "Winzip",
to
zip some specific files. Can anyone advise how to do it??
Thanks a million in advance!

Ivan