VBA code - to copy a name from a list to a template

[Jo Ann Kaminski]

I have the below VBA code that is working well for my task but I'd like to expand this to include the name from the list into the template that is created. There is line of code that indicates it could be used to make this happen, which I have underlined below - I just don't know how to make it work?

Sub SaveMasterAs()

'Excel 10 Tutorial

Dim wb As Workbook

Dim rNames As Range, c As Range, r As Range

'Current file's list of names and ids on sheet1.

Set rNames = Worksheets("Sheet1").Range("A2", Worksheets("Sheet1").Range("A2").End(xlDown))

'Path and name to master workbook to open for copy, saveas.

Set wb = Workbooks.Open(ThisWorkbook.Path & "\Template.xlsx")

For Each c In rNames

With wb

'If You Need To Copy Something To the Template Use this line

.Worksheets("Sheet1").Range("A1").Value = c.Offset(, 1).Value 'ID

'Path and name for copied workbook

.SaveAs Filename:=ThisWorkbook.Path & "\Template Copy\" & c.Value & ".xlsx", FileFormat:=xlOpenXMLWorkbook, CreateBackup:=False

End With

Set wb = ActiveWorkbook

Next c

wb.Close

End Sub

 

[Tom.Jones]

What's going on DanteAmor?
Did your crystal ball break? and you don't see the file anymore?
Sin. It needs to be repaired...

 

[Jo Ann Kaminski]

I'm sorry, although I'd like to, I can't provide further assistance without the proper data. It is difficult to guess the name of your sheets in each book, how many sheets you have in each book, what is the name of each book, and also you modify the macro and make me responsible for the errors of the macro.

So sorry! I thought the picture I attached was what you needed to show you the names of the tabs in the workbook. I do appreciate your assistance to this point and I by no means was holding you accountable for the errors. This is on me.

 

[Jo Ann Kaminski]

Can I ask if you can take one more look? I feel we are so close to fixing this and making it work. If not would anyone else be willing to give this a try? Really could use the help.

 

[DanteAmor]

This is where you should put all the relevant information about your books, book names, sheet names, how many sheets you have in each book, etc, etc.


By the way. The name of the sheet is not visible in this image:

So, in order for you to receive help from me or someone else, you must provide all the information, complete, I already posted 3 codes and none of them work for you. I can't keep trying to guess how your sheets are.

It is also not enough to say: the macro does not work.

You must write here what you modified to the macro. Because each of the macros that I have given you works for me, but you modify them and then you simply come with your comment: it still doesn't work.