Create File Folder from list & create file with header row in each

[3345james]

I have a list of 600+ companies that I need to create a file folder for.
The below macro works well to produce the folder in the directory I place my worksheet.
I also need to place into the new folder a xlsx file with a specific name but with the same header row labels

The attached file Test_Data.
Column B has the folder that needs to be created
Column D has the file that needs to be created within that folder
F1:H1 has the header row that needs to be created in each file.

Please Login or Register  to view this content.

[sintek]

Here you go...

Please Login or Register  to view this content.

Edit added red r in code...

PS, code will only work if folder does not exist...

Will there ever be a instance where the folder already exists and you need to do something to it?

[3345james]

ran without error but nothing was created

Did a search for the folder name but nothing.

[sintek]

Runs perfectly for me...Did you see the change in code red r

[3345james]

Yes saw the 'r' - Compile error without it.

I went back and tried again - still nothing. I reran my macro for creating a folder and it worked (then deleted the created folders)
tried placing my Test_data in another dir and retried - still nothing

[sintek]

You do have the File that houses the macro saved somewhere?
The code runs and creates all folders and files within at that same path...
Works perfectly...Not sure what else it can be

[3345james]

Had it saved in my PERSONAL

Changed Test_Data to macro enabled worksheet and ran - works fine - thanks!

[sintek]

Glad you figured it out...Tx for rep +