Run .BAT from vb script

[davidpayten]

Hi All,

I want to run a .BAT file that will unzip a file for me. Atm i cannot find a way of executing winzip from vb script effectively and thought this would be a nice workaround since I have a bat file that does this for me.

So, q is "How do you create .BAT as an object / how would I get this to work?

Any ideas would be much appreciated.

Thanks!

Dave

 

[Ivan F Moala]

Hi All,

I want to run a .BAT file that will unzip a file for me. Atm i cannot find a way of executing winzip from vb script effectively and thought this would be a nice workaround since I have a bat file that does this for me.

So, q is "How do you create .BAT as an object / how would I get this to work?

Any ideas would be much appreciated.

Thanks!

Dave

one way to do this

Shell "C:\WINDOWS\system32\cmd.exe" & " C:\YourDirectory\YouBatFileName.BAT"

 

[mvptomlinson]

Here's some vba code that can unzip files without calling a .bat file. Perhaps it can be adjusted to suit your needs: http://www.rondebruin.nl/unzip.htm

 

[davidpayten]

Thanks for the replys guys. This forum rocks

 

[DonkeyOte]

Just for ref in case someone else is looking into this at a later date...

if you did want to unzip via .BAT you could use another utility (freeware) such as 7-zip

Below would zip files

"C:\Program Files\7-zip\7z.exe" a -tzip "full path of to be created zip file" "full path of file to be zipped"

unzip

"C:\Program Files\7-zip\7z.exe" x "full path of file to be unzipped" -o "full path of folder into which unzipped files & folders to be extracted" -y