VBA to copy a template worksheet to new excel workbook
 

I have created a template with a Worksheet called "Certificate".

There is a userform that is opened on Auto_Open of this template and
allows a file name and some other parameters to be input.

On pressing the OK button on this form, I want to do the following.

1. Create a new XLS workbook with the file name entered on the form
(this includes the full Windows folder address).

2. Copy the Certificate workbook from the template across to this new
file.

3. Close the original template (maybe closing needs to be done at the
end??) and make the "Certifcate" worksheet in the new workbook the
active worksheet.

4. Using the parameters entered on the userform, change the details in
"Certificate" (this code is already written but not set up for the new
workbook - currently it updates the template "Certificate" worksheet)

5. Save the new excel workbook with the changes.

I know this should be simple but I am really struggling. Please can
anyone help?

Cheers

Mark