VBA, Compressing to Zip files within VBA

Compressing to Zip files within VBA

Author	Message
David Fo #1 / 5	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

Kim Mitchel #2 / 5	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

David Fo #3 / 5	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

Derek Coope #4 / 5	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

Jose Hernande #5 / 5	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

Page 1 of 1

[ 5 post ]