UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> Use vba to zip up folders to Windows Zip utiliity    
 
   
fiftyfour
post May 17 2010, 01:11 PM
Post #1

UtterAccess Guru
Posts: 774
From: Illinois
I have a program that transfers about a dozen spreadsheets to a folder C:\MySpredsheets. I would like to use vba to zip up those spreadsheets into one zip folder. Then, for another program, I would like to use vba to unzip this zipped up folder to a pre-chosen (using the FileOpen API) folder.

Can you please help me?

Thanks,

Fiftyfour
Go to the top of the page
 
+
Doug Steele
post May 17 2010, 01:18 PM
Post #2

UtterAccess VIP
Posts: 17,790
From: Don Mills, ON (Canada)
See whether my article Working with Compressed (zipped) folders in MS Access helps.
Go to the top of the page
 
+
fiftyfour
post May 17 2010, 01:25 PM
Post #3

UtterAccess Guru
Posts: 774
From: Illinois
Doug...that's exactly what I was looking for...thank you so much...
Go to the top of the page
 
+
« Next Oldest · Access Automation · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 18th June 2013 - 01:33 AM