Runing a WZZIP.exe from Excel VBA?

[MyFlight]

I am trying to figure out how to run WZZIP.exe (the command line interface for WinZip from VBA. I have multiple VBA Modules and macros that run and I need to zip all of the files prior to running these macros (in case of problems). All files begin with a 7 digit number followed by an Underscore and then the text file name. I need to zip any file in C:\temp files\ with 1234567_*.txt into a zip file named 1234567.zip.
If anyone has any suggestions or could point me in the right direction I would appreciate it.

 

[HarleyQuinn]

thread705-875484 may be of some use to you.

Hope this helps

HarleyQuinn
---------------------------------
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe Martin

Get the most out of Tek-Tips, read FAQ222-2244 before posting.

http://lessthandot.com