Extracting zipped files

[BeckyLee]

Please help. I am trying to unzip files in Access 97 VBA and extract them into a directory. Before my IT department upgraded our computers from Windows 2000 to Windows XP I had a shell command in my module that did the following:

target = "C:\temp\NYISO"
Shell ("C:\Program Files\WinZip\WINZIP32.EXE -min -e -o " _ & """" & source_file & """" & " " & """" & target & """")

With the upgrade to XP my IT has removed the WINZIP32 application.

How do modify this code to extract the files?

Thank you,
Becky

 

[HitechUser]

becky,

I may be wrong, but I do not believe there is a way to call the builtin Zip support in Windows XP. Thre are many people just turing it off. Does your IT department not know how to disable it? Or did they not want to use it to save money?

Here is a link for a freeware product (if that helps). It supports command line parameters similar to the ones you are using.

http://www.7-zip.org

Good Luck...

 

[BeckyLee]

HitechUser,
Thank you for your respond, but our computers are locked down I can't not download any software on my PC or my co-workers PC's who would also be using the application.

Do you have any other suggestions?
Becky

 

[HitechUser]

Becky,

Try a workaround! Use a DOS based Unzip utility. This can be copyed to a directory and ran (No install process for windows to stop). So much for IT.

These DOS utilies can extract files, but please note some of them do NOT support windows long filenames. You will have to use the "shortname".

Search the net for DOS zip utilities. The one that started it all is PKZIP (version 2.04G).

http://www.pcworld.com/downloads/file_description/0,fid,1233,00.asp

Also, you can purchase PKZIP 2.50. It does support long filenames (although I have not used it).

Good Luck...

 

[HitechUser]

Maybe this

http://www.info-zip.org