Macro to create alot of new blank excel files, saved as specific names, in specific file directories

[phobo]

I have used a macro to create a bunch of folders and filed sub folders into main ones. I now wish to create an excel spread sheet titles as names in a column and file them within each sub folder.

Image as an example

using simple formulas I can make column A = File path and Column B = File Path Directory.

Would anyone have a macro to perform this function?

 

[phobo]

Could someone point me into the right direction? I can combine a bunch of macro's but I am having trouble finding one to create the excel files.