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

Hi Ivan,

See the Shell function in VBA help.


---
Regards,
Norman


"Ivan" <Ivan@discussions.microsoft.com> wrote in message
news:5754F2CD-484D-4324-A0CA-E2429BF3A4E3@microsoft.com...
> 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

Hi Ivan,

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

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


---
Regards,
Norman



"Ivan" <Ivan@discussions.microsoft.com> wrote in message
news:5754F2CD-484D-4324-A0CA-E2429BF3A4E3@microsoft.com...
> 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

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" <Ivan@discussions.microsoft.com> wrote in message
> news:5754F2CD-484D-4324-A0CA-E2429BF3A4E3@microsoft.com...
> > 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
>
>
>