Winzip - Shell Execute

[FastOneBaz]

Hi

Anyone have any tips about calling winzip from VBA?

I can open the winzip interface using :

Dim RetVal
RetVal = Shell("C:\Program Files\WinZip\WINZIP32.EXE", vbNormalFocus)

But I don't know what arguments to use to control which file get
zipped and where it goes.

Can I do this?
All help appreciated, cheer

 

[Ron de Bruin]

Hi FastOneBaz

I have some code on this page
http://www.rondebruin.nl/zip.htm

 

[FastOneBaz]

thanks for the code, ideal

 

[Ron de Bruin]

You are welcome