Hello Guys!
I am really new with VBA, i hope You can help me with this.
My girlfriend got a task at her workplace, to create 400+ excel files. I think this could be easily done with VBA.
I tried many codes, but unfortunately i don't have the knowlege to modify them at the moment, but i really want to help her.
I have a template excel file : TMP.xlsx and an excel file with the lists of the file names and save paths: List.xlsx. Both of them have only one worksheet.
The VBA code should do the followings:
1. Create new folders and name them after the values in column B in the "list" file. (it would be nice if the path of the master folder could be added manually in a textbox)
2. Copy the cell value from column A from the "list.xlsx" file into the "TMP.xlsx" file's B5 cell.
3. Save the modified template files. Filenames: cell values in column A in "list.xlsx" file. Save path: cell values in column C in "list.xlsx" file.
Your help could save her from a lot of work. :D
Thank you very much in advance!
I am really new with VBA, i hope You can help me with this.
My girlfriend got a task at her workplace, to create 400+ excel files. I think this could be easily done with VBA.
I tried many codes, but unfortunately i don't have the knowlege to modify them at the moment, but i really want to help her.
I have a template excel file : TMP.xlsx and an excel file with the lists of the file names and save paths: List.xlsx. Both of them have only one worksheet.
The VBA code should do the followings:
1. Create new folders and name them after the values in column B in the "list" file. (it would be nice if the path of the master folder could be added manually in a textbox)
2. Copy the cell value from column A from the "list.xlsx" file into the "TMP.xlsx" file's B5 cell.
3. Save the modified template files. Filenames: cell values in column A in "list.xlsx" file. Save path: cell values in column C in "list.xlsx" file.
Your help could save her from a lot of work. :D
Thank you very much in advance!
