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

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.
You must log in or register to reply here.

Similar threads

A
  • Question
Outlook Marco for "Search folder and move the item" no longer works
Replies
0
Views
159
ashringg
A
S
  • Question
A little help with batch file
Replies
9
Views
503
snjpverma
S
W
  • Question
Excel 2021 pro plus on win 11 - File in use locked on a local pc (no domain) and single user
Replies
2
Views
505
webmasterone
W
M
  • Question
Word VBA opens Excel workbook as read-only even though it was not originally created as such
Replies
1
Views
396
NdNoviceHlp
NdNoviceHlp
S
  • Solved
VBA works in Word 2016 and throws error in Word 2019 and 365
Replies
4
Views
618
NdNoviceHlp
NdNoviceHlp

Forum statistics

Threads
1,215,433
Messages
6,124,861
Members
449,194
Latest member
HellScout

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