Hi all,

I work in a Training environment. I have a workbook (Registrations.xlsm) which i use to register client details (name, registration date, contact details etc.). Each client also requires an individual workbook/Report Card (e.g. CHT-130514,Smith, J.xls) which monitors their progress through our company.

In the Registrations workbook, one cell in each record contains an expression which constructs a unique Id number for each client using their name and registration date (i.e. CHT-130514,Smith, J. Once a new client record is input, the User selects the cell containing the unique Id number and runs the macro from there. The cell data is then passed to the variable [wbName] and used as the workbook/Report Card file name.

I have got the VBA as follows:

Dim wbName As String
    wbName = Selection.Value
    Dim newBook As Workbook
    Set newBook = Workbooks.Add
    With newBook
        .Title = wbName
        .SaveAs filename:="K:\SUPPORT\CHT-Training\TestFilenameFolder\" & wbName, FileFormat:=52
    End With

What i cannot do is use my Report Card template, rather than the default blank workbook template, to create the new workbook.

Anyone done anything like this before?