Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Possible to copy worksheet into template? | Excel Discussion (Misc queries) | |||
Copy Filterd Data from worksheet to another workbook template | Excel Discussion (Misc queries) | |||
Copy Excel Worksheet to another workbook | Excel Programming | |||
Excel 2007 copy/move worksheet to another workbook | Excel Discussion (Misc queries) | |||
VBA Code to copy a worksheet to another Excel Workbook | Excel Programming |