XP compressed file from VBA

  • Thread starter Thread starter Bill
  • Start date Start date
B

Bill

I need to create an XP compressed file from
VBA code. Is there an XP module that can
be called that will create a "zip" file?

Thanks,
Bill
 
No, you will need a product that creates zip files. That product will also
have to have command line capabilities. That is, the ability to pass the
product file name, etc.

There are several available. I use Winzip. It will not work with the free
"trial" version, You will have to purchase the product to get the command
line capability. then, you will need to call it with the Shell statement.
 
I have WinZip, but I can't depend on my XP clients
having that product on their machines.
Bill
 
Do you have the licensed version? If you do, then you have the command line
capability. Unfortunately, it does require a license for each user, but it
is only $29, so not that big an issue. Here is the URL:

http://www.winzip.com/winzip.htm

I don't think there is a way around using a third party product.
 
Bill,

I poked around a little in microsoft.public.windowsxp.general
filtering on 'zip' and there are some scripts that might work
or at least get you started.

A question or two in that group could get the attention of an
XP scripting guru.

HTH
 
Hi Steve,
Looks like maybe the dll interface in Zlib has some
possibilities. Is that what you came across at "granite"?
Bill
 
Bill,

I am sorry, I have not used any of these myself, so I am not able to
advise specifically. As for the Info-Zip libraries, there is some
information here...
http://www.vbaccelerator.com/home/VB/Code/Libraries/Compression/Zipping_Files/article.asp
I guess you need to include a Reference to the dll in your mdb, and use
the supplied properties and methods to make it do what you want. There
should be no need for you to be messing around with C++ code.

The other one that I would be inclined to give a try would be
http://www.molestudio.com/tools/molezip/ Thet have a users' forum,
which may be a good resource for getting started, and the download comes
with some sample code.

Good luck. Please post back if you manage to succeed with any of these.
:-)
 
Thanks Steve, I'll investigate these leads later today, PST, and
post back with whatever I find.
Bill
 
Steve,
I think that either MoleZip or Info-Zip can be made to
satisfy the requirement to compress files from within VBA.
I'm going to put this on the "back-burner" for a week or
so while I attend to some pressing requests for updated
documentation for one of my projects.

As it stands now, WinZip seems to be widely used and
my code currently uses the command-line interface in
WinZip to create the needed zip files. The reason for my
inquiries is an anticipation that some new users might be
without WinZip and I didn't want to force that upon them.

Since this thread will become cold, I'll open a new thread
when the time comes to re-visit in detail. By the way, the
forum at MoleZip doesn't seem to get much use and what
messages there even remotely relating to VBA applications
were not of much help.

Thanks for your thoughts and leads, as they got me to a
source of information that may very well offer a solution
if I find I must abandon WinZip.

Bill
 
Back
Top