Copy a Folder Template and Create Multiple Folders Based on an Excel Spreadsheet

[kwooden0626]

Hello,

I created a folder template which has several sub-folders. I want to copy this template and create new folders with names from an excel spreadsheet. The path for this template is: C:\Users\woodenk\Documents\Employee Personnel Files\_Folder Template. I also placed the spreadsheet inside the same directory and the filename is: Employees.xlsx.

Is it possible to create a VBA script that will copy my folder template and create new folders based on the names entered in Column A on my excel spreadsheet?

 

[=ODIN=]

Have you given a shot to piecing any of this code together yourself?

 

[kwooden0626]

I've never written a code and don't even know where to begin.