File Naming Convention Macro

My code below creates a new workbook for every cell in Column A starting with A3 and stops when their is no more data. It then copies the data in each cell in column A to cell A4 on the "Input" sheet. So for example, if I had data in A3 and A4 only then I would have 2 workbooks saved each being named after the data that is in cells A3 and A4.

So that code is working right, but what I am trying to do is to add another layer to my workbook file naming convention. Now in addition to naming the file after the data found in each cell Column in A I want it to name the file after the data in column B too. So for example if A3= John and B3=Smith and A4=Peter and B4=Parker then I would end up with two workbooks which are named "JohnSmith.xlsm" and "PeterParker.xlsm"

Does any one know how to do this?
Thanks

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Regards, TMS

You're welcome.



If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.