Zip multiple folders with smartcrypt

J

Jonyang

New Member
Joined
Mar 16, 2017
Messages
31
Hi everyone,

I have about 200 folders in C:\users\fkuf77\desktop\test\testwb folder. And I want to individually zip all of the sub folder within the given path above and save it back in the same folder. How do I do that using VBA?
 

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.
You must log in or register to reply here.

Similar threads

J
  • Solved
Saving email attachments with VBA - code *nearly* working
Replies
7
Views
379
John_w
J
A
  • Question Question
Copying whole word document, into excel + formatting columns and cells
Replies
1
Views
374
Macropod
Macropod
N
  • Question Question
PowerPoint VBA to insert Photos not working
Replies
4
Views
178
NeoSez
N
A
  • Question Question
Outlook Marco for "Search folder and move the item" no longer works
Replies
0
Views
312
ashringg
A
B
  • Question Question
Looking for Solution for User Authorization to An Excel Workbook
Replies
0
Views
224
bisel
B

Forum statistics

Threads
1,225,685
Messages
6,186,427
Members
453,354
Latest member
Ubermensch22

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top