Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Zip VBA Shell (Zip multiple folders in a main folder)

Posted on 2013-06-05
4
Medium Priority
?
523 Views
Last Modified: 2013-06-06
Hello

There are 3-15 folders in a big folder. Need VBA or some other way to do this:
If the main folder is C:\Main, then if there are any folders in that directory, zip it please.
So for example – if there are 4 folders in C:\Main, then after this code magic, 4 zipped files are created out of those 4 folders.
0
Comment
Question by:Rayne
  • 2
  • 2
4 Comments
 

Author Comment

by:Rayne
ID: 39223946
thank you
0
 
LVL 21

Accepted Solution

by:
Boyd (HiTechCoach) Trimmell, Microsoft Access MVP earned 2000 total points
ID: 39224054
0
 

Author Comment

by:Rayne
ID: 39225949
thanks TheHiTechCoach
0
 
LVL 21
ID: 39226758
You're welcome!
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…

564 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question