| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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/ |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Winzip - Shell Execute
|
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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/ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calling WinZip from Excel | Excel Programming | |||
| WinZip | Excel Programming | |||
| winzip in macro | Excel Programming | |||
| Open WinZip from Excel | Excel Programming | |||
| WinZip extract | Excel Programming | |||
![FastOneBaz[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
