Un-Zip with VBA

[SgtPepps]

This isn't important but is anyone aware of a way to automate un-zipping files using VBA. I could use SendKeys but that would be a horrendous way of doing it.

Mike

Hold the Wheel and drive

 

[robcarr]

Mike,
I posted the same question about 2 weeks ago, see the responses on this below.

Several options, but the one I would tend to use is embed a call using WScript.

See:

http://www.devguru.com/Technologies/wsh/quickref/wshshell_Run.html

Provides a brief code snippet.

Hope this helps.
DougCranston

goto the winxip website and look for the command line addin download...

http://www.winzip.com/wzcline.htm

example:

shell "c:\program files\winzip\wzzip C:\my_zip_path\my_zip_file.zip c:\my_path\my_name.TXT"

...you may need to pause the vba code execution when using this command. if so look to this FAQ

FAQ707-2542

The answer of your stated question/problem:
--------------------------------------------
Pack and unpack an Excel-Workbook with WinZip

http://www.excel-center.com/mailing/062699h.htm

Other related info:
----------------------
Using ShellExecute to start any program or short cut from inside VBA

http://www.suodenjoki.dk/produktioner/artikler/vba_shellexecute_article.asp

Executing notepad using VB in Excel

http://www.experts-exchange.com/Programming/Programming_Languages/Visual_Basic/Q_11631738.html

Shell Statement v1.0

http://codelib.aspemporium.com/index.aspx?pid=3&cid=4

What command line parameters does WinZip support?

http://www.winzip.com/xcmdline.htm

WinZip Command Line Support Add-On

http://www.winzip.com/other.htm

Hope this helps.
DougCranston



Thanks Rob.

 

[SgtPepps]

Good Man! thankyou for your responce and sorry for my missing your previous post. I'll let you know how i get on.

Mike

Hold the Wheel and drive