Forum

VBA to create Folde...
 
Notifications
Clear all

VBA to create Folder - for backup

3 Posts
2 Users
0 Reactions
106 Views
(@david_ng)
Posts: 310
Reputable Member
Topic starter
 

Is there a macro can auto create Folder, by type [ eg Invoice , PO, etc  ]  by month and year ?

 

eg in d:Invoice

        d:Purchase Order

 

Jan_2020_Invoice         Jul_2020_Invoice    

Jan_2020_Invoice         Jul_2020_Invoice

Feb_ 2020_Invoice      Aug_2020_Invoice

Mar_2020_Invoice      Sep_2020_Invoice

Apr_2020_Invoice       Oct_2020_Invoice

May_ 2020_Invoice      Nov_2020_Invoice

Jun_2020_Invoice        Dec_2020_Invoice

 

 

Jan_2020_PO         Jul_2020_PO
 
Feb_ 2020_PO     Aug_2020_PO
 
Mar_2020_PO     Sep_2020_PO
 
Apr_2020_PO       Oct_2020_PO
 
May_ 2020_PO     Nov_2020_PO
 
Jun_2020_PO       Dec_2020_PO
 
Posted : 19/06/2020 5:39 am
Philip Treacy
(@philipt)
Posts: 1632
Member Admin
 

Hi David,

You can use FileSystemObject to create folders.  This post has some code you can adapt

https://www.myonlinetraininghub.com/excel-forum/vba-macros/using-excel-to-create-directory-structure

Regards

Phil

 
Posted : 19/06/2020 8:58 am
(@david_ng)
Posts: 310
Reputable Member
Topic starter
 

Thanks Philip will try on this!

 
Posted : 19/06/2020 8:51 pm
Share: