?
Solved

DLL needed for zipping files using VBA that works with 64 bit OS

Posted on 2013-05-24
9
Medium Priority
?
1,094 Views
Last Modified: 2013-05-30
I've been using the dll file 'xzip.dll' for zipping files.(Made by XStandard). But they don't have a 64 bit version and the 32bit version doesn't work within 64 bit Office. . Anyone have a recommendation. It doesn't have to be freeware.

Or is there now a zipping function or API provided by the 64Bit OS that I can use?

I'm developing this in MSAccess 2010 using VBA. Needs to work for 64Bit office.

John
0
Comment
Question by:askolits
9 Comments
 
LVL 22

Expert Comment

by:Haresh Nikumbh
ID: 39193916
0
 
LVL 14

Accepted Solution

by:
Alexander Eßer [Alex140181] earned 2000 total points
ID: 39193918
0
 

Author Comment

by:askolits
ID: 39193936
Takecoffe: I may look into it, and although I said it does't have to be freeware, $900/yr is way too much.

Alexl40181: In the first link, it looks like it will unzip files, but I also need to zip them.

The second link is the same program I mentioned in my original post. They don't have a 64 bit version. I already asked them.
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 

Author Comment

by:askolits
ID: 39193943
Alexl40181: Just saw a second link within  your firstexample. I think that may work for me. I'll let you know
0
 

Expert Comment

by:AndyHoughtonCanada
ID: 39194243
I have used the freeware 7zip version here:
http://www.7-zip.org/

They have a 64 bit version.

Here is the code I have used in the past:

    ' 7z.exe,7z.dll Need to have Zip in same location as the Access file
    ' src - must end in \*.*
    ' 7z - 7zip does not erase files on zip, need to erase separately.
    cmd = Chr$(34) & fGetSystemLocation() & "7z.exe" & Chr$(34) & " u -bd -tzip -y -r " & Chr$(34) & ZipFileDir & Chr$(34) & " " & Chr$(34) & src & Chr$(34)
    ExecCmd cmd   ' This waits for execution to finish, this only    r = Shell(cmd)

I hope this helps.
[Edited by SouthMod]
0
 
LVL 28

Expert Comment

by:omgang
ID: 39194478
Are you set on using a utilitity or can you use native OS zip functionality to accomplish the task?  I have VBA code for Access to zip files using just the OS.
OM Gang
0
 

Author Comment

by:askolits
ID: 39197278
OM Gang:  I think the second link that Alex40181 provided may work, and it uses the OS. So far it worked on both an XP and Win 7 machine running Access 2003, and 2010 32Bit.  Just need to test it for Office 64Bit and we should be all set.

I won't know for sure till next week. If not, I may have to use the suggestion from by: AndyHoughtonCanada. I'll let you  all know how it turns out.

John
0
 

Author Comment

by:askolits
ID: 39206747
Still testing this. Will get back to you all shortly
0
 

Author Closing Comment

by:askolits
ID: 39209847
This first link had the solution.

Thanks!
0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
Sometimes MS breaks things just for fun... In Access 2003, only the maximum allowable SQL string length could cause problems as you built a recordset. Now, when using string data in a WHERE clause, the 'identifier' maximum is 128 characters. So, …
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question