Compressing to Zip files within VBA 
Author Message
 Compressing to Zip files within VBA

Hello All

Win XP, Office 2002, VBA 6.3

I've just upgrade to XP Pro.
In this OS if you right click on a file in Explorer there is a SendTo option
to compress it to a Zip file..

Is there a way to do this within VBA?

I'm currently using Winzip's command line options but if there's an internal
method it would be much easier.

Thanks in advance

Dave



Sun, 24 Apr 2005 18:13:44 GMT  
 Compressing to Zip files within VBA
If you have WinZip, then the Shell command may be the easiest way to go.
Check out "Shell" in help.

Kim


Quote:
> Hello All

> Win XP, Office 2002, VBA 6.3

> I've just upgrade to XP Pro.
> In this OS if you right click on a file in Explorer there is a SendTo
option
> to compress it to a Zip file..

> Is there a way to do this within VBA?

> I'm currently using Winzip's command line options but if there's an
internal
> method it would be much easier.

> Thanks in advance

> Dave



Mon, 25 Apr 2005 00:05:54 GMT  
 Compressing to Zip files within VBA
Yes, as I said, I'm using WinZip already (with the shell command), but XP
now seems to have zip compression built into it, and I'm trying to find a
way of using it.

Dave


Quote:
> If you have WinZip, then the Shell command may be the easiest way to go.
> Check out "Shell" in help.

> Kim



> > Hello All

> > Win XP, Office 2002, VBA 6.3

> > I've just upgrade to XP Pro.
> > In this OS if you right click on a file in Explorer there is a SendTo
> option
> > to compress it to a Zip file..

> > Is there a way to do this within VBA?

> > I'm currently using Winzip's command line options but if there's an
> internal
> > method it would be much easier.

> > Thanks in advance

> > Dave



Mon, 25 Apr 2005 18:48:43 GMT  
 Compressing to Zip files within VBA
I responded to a posting titled "System calls to XP file zip and Send To
mail recipient?" in the microsoft.public.access.forms newsgroup yesterday.
You might want to follow that thread.

I believe this is not possible at this time.  Even if it is, are you sure
you want to require that your users run Windows XP?

Derek Cooper
Database9
www.database9.com


Quote:
> Hello All

> Win XP, Office 2002, VBA 6.3

> I've just upgrade to XP Pro.
> In this OS if you right click on a file in Explorer there is a SendTo
option
> to compress it to a Zip file..

> Is there a way to do this within VBA?

> I'm currently using Winzip's command line options but if there's an
internal
> method it would be much easier.

> Thanks in advance

> Dave



Thu, 28 Apr 2005 00:23:57 GMT  
 Compressing to Zip files within VBA
One option is to use the zip32.dll available at
http://www.info-zip.org/pub/infozip/Info-ZIP.html (Used by WinZip) to zip
your files. There is a link to a VB sample available on the site.

HTH

Jose Hernandez


Quote:
> Hello All

> Win XP, Office 2002, VBA 6.3

> I've just upgrade to XP Pro.
> In this OS if you right click on a file in Explorer there is a SendTo
option
> to compress it to a Zip file..

> Is there a way to do this within VBA?

> I'm currently using Winzip's command line options but if there's an
internal
> method it would be much easier.

> Thanks in advance

> Dave



Thu, 28 Apr 2005 03:11:10 GMT  
 
 [ 5 post ] 

 Relevant Pages 

1. COMPRESS/DECOMPRESS files----.zip included, I think

2. Looking for a VBX-control to compress (zip) files

3. compressing/Zipping files.

4. Compressing Access files from within VB code

5. Backing up / compressing a data file from within an app

6. Compressing a file from within VBS

7. how to compress files from within the code

8. how to compress a file from within the code

9. VBA to dump zip file contents to a file

10. ZIP files from within Access code

11. Reading files from a zip file (Just reading the filenames, not unzipping or zipping)

12. ZIP compress OCX?

 

 
Powered by phpBB® Forum Software