Multiboard
New Member
- Joined
- Mar 7, 2024
- Messages
- 5
- Office Version
- 365
- Platform
- Windows
Hello all and thank you very much for your contribution to this platform.
I'm very very new to VBA and I was wondering if you could help in creating a macro which produces multiple workbooks as well as renaming them.
I have a folder on my desktop called Test1 which contains 2 excel files, wkb and Master_file.
For the file called wkb, the column A contains a list of numerical codes except the cell A1 which is the header called Filenames.
All I'm trying to do is to create a macro where once actioned, it will create copies of the Master_file and rename these as per the codes in column A which can contain 1 as well as 100.
For instance, say the cell A2= 222, then the new workbook will be a copy of the Master_file and will be renamed 222.xlxs
Lastly, I would like all the new workbooks to be saved in a folder called Test2 located on my desktop at C:\Users\Multiboard\Desktop\Test2
I would like to kindkly ask you if you could help in creating a macro for the above query.
I bought a book about VBA and Macros by Miscrosoft but at the moment I'm finding it not really easy
Thank you.
I'm very very new to VBA and I was wondering if you could help in creating a macro which produces multiple workbooks as well as renaming them.
I have a folder on my desktop called Test1 which contains 2 excel files, wkb and Master_file.
For the file called wkb, the column A contains a list of numerical codes except the cell A1 which is the header called Filenames.
All I'm trying to do is to create a macro where once actioned, it will create copies of the Master_file and rename these as per the codes in column A which can contain 1 as well as 100.
For instance, say the cell A2= 222, then the new workbook will be a copy of the Master_file and will be renamed 222.xlxs
Lastly, I would like all the new workbooks to be saved in a folder called Test2 located on my desktop at C:\Users\Multiboard\Desktop\Test2
I would like to kindkly ask you if you could help in creating a macro for the above query.
I bought a book about VBA and Macros by Miscrosoft but at the moment I'm finding it not really easy

Thank you.