Automatically unzipping files

[sparx]

I have over 500 winzip files, does anyone have a clue how I can unizip this files without having to do this manually.

Thanks for your help,

Erik

 

[dcx693]

Are you sure you posted this in the right forum? You want to do this from Access using VBA?

 

[sparx]

To be honest with you, I'm not sure how this would be possible, what would you suggest?

 

[John.Woody]

Winzip has a comand line add on called wzcline. You could use the shell command in access to run wzunzip from to. You would need a table to store the location and zip file names, and the location for the unzipped files. The help provided with wzcline gives you info and switch information.

 

[dcx693]

If you have a valid WinZip 9.0 license you can also use this: http://www.winzip.com/prodpagecl.htm

 

[sparx]

Thanks a lot for your help guys, much appreciated. I'll do some research on that.