Zip Files

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to create zip files using code in excel?
Something that could browse files, select some and zip
them up.
 
Is there a way to create zip files using code in excel?
Something that could browse files, select some and zip
them up.
Click to expand...

You need the WINZIP command line utility for that. Search the WINZIP
site www.winzip.com for it and install it. Then you can use SHELL to
start the utility after constructing the proper commandline for it as a
string.

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com
 
I just finished yesterday an Excel-Program to Zip
specified files in specified Zip-files. For this you need
the Command Line AddOn WZCline (WZZip) from WinZip
(Download).
If you would like to test my program please send me your E-
Mail Address and I will sen you the program.

Regards
Klaus
 
Will other users of this spreadsheet require the winzip
commandline program to be installed? If that is the case
this is not an appropriate solution for me. If so, is
there anything else that can be done?
 
Will other users of this spreadsheet require the winzip
commandline program to be installed? If that is the case
this is not an appropriate solution for me.
Click to expand...

Yes they do.

Search google for VB compression routines is all you can do then.

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com
 
Hi Anne Onymous,

No, other users will not require the commandline version of Winzip to be
installed.

If they are using XP or XP Pro, then both these operating systems support
the zip format and can decompress and read them.
For all other operating systems the users will require a copy of the
standard WinZip (or equivalent) utility to decompress and read the file.

As an alternative, if you have purchased the full version of WinZip, this
contains an option to make an .exe self-extracting file. However, although
you can create a zip file from within Excel, you would still have to create
the self-extracting file outside of Excel. This is done in one of two ways:
either from within the Winzip program or, if you are using one of the XP
operating systems from within Explorer. In Explorer, browse to the zip file
you have created and right click on it. Winzip adds its own menu to the
dropdown menu; from within this there is an option to create the .exe.

HTH

--
Regards
Andy Wiggins
www.BygSoftware.com
Home of "Save and BackUp",
"The Excel Auditor" and "Byg Tools for VBA"
 
Back
Top