How to automatically create folders based on file name and zip the folder using vba

Asked Aug 25 '23 at 11:40

Active Aug 25 '23 at 11:44

Viewed 40 times

-2

Hi I am new to VBA I have 20 Excel file in a folder

Excel file named as

Chennai 
Hyderabad
Kolkata
Delhi
Pune
Kerala
Madurai 
Kanchipuram
Theni
Karnataka
Assam
Andhra Pradesh
Telangana 
Jammu and Kashmir 
West bengal
Hyderabad 
Bengaluru 
Lucknow
Rajashthan

I need to create folders on individual excel files,folder name and excel file name should be same and want to automatically zip the individual folders Using vba Can anyone help me with the code

edited Aug 25 '23 at 11:44

cigien

57,834
11
73
112

asked Aug 25 '23 at 11:40

ramya

1

What have you tried so far? – Shrotter Aug 25 '23 at 11:45
You can zip with the `Zip` function from my library at **GitHub**: [VBA.Compress](https://github.com/GustavBrock/VBA.Compress). – Gustav Aug 25 '23 at 11:45
Perhaps check out this; https://stackoverflow.com/q/10380312/4961700 – Solar Mike Aug 25 '23 at 12:49

How to automatically create folders based on file name and zip the folder using vba

0 Answers0