Winzip - Shell Execute
 

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

--
Message posted from http://www.ExcelForum.com

Winzip - Shell Execute
 

Hi FastOneBaz

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

--
Regards Ron de Bruin
http://www.rondebruin.nl


"FastOneBaz " wrote in message ...
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 gets
zipped and where it goes.

Can I do this?
All help appreciated, cheers


---
Message posted from http://www.ExcelForum.com/

Winzip - Shell Execute
 

thanks for the code, ideal

--
Message posted from http://www.ExcelForum.com

Winzip - Shell Execute
 

You are welcome

--
Regards Ron de Bruin
http://www.rondebruin.nl


"FastOneBaz " wrote in message ...
thanks for the code, ideal.


---
Message posted from http://www.ExcelForum.com/