Hi guys, I would like to create a macro which opens a template and saves a COPY of the template as a new workbook in the same location of the template. What I had in mind was that when the macro is run the following will happen: Step 1:Opens an already saved template from its location Step 2: A Command Button pops up, prompting the user to insert the name of the new document (the new document will be copy of the template) Step 3: The new document is saved as a macro-enabled workbook with the name inserted in step 2 above. I had posted the same question in a similar forum, but thought I'd get more insight in this regard: Macro to open a Template and save a new workbook Is this possible? Thanks a lot guys !

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Macro to open a Template and save a new workbook

Thread starter Keibri
Start date Jun 10, 2015

Keibri

New Member

Jun 10, 2015

Hi guys,

I would like to create a macro which opens a template and saves a COPY of the template as a new workbook in the same location of the template.

What I had in mind was that when the macro is run the following will happen:

Step 1:Opens an already saved template from its location
Step 2: A Command Button pops up, prompting the user to insert the name of the new document (the new document will be copy of the template)
Step 3: The new document is saved as a macro-enabled workbook with the name inserted in step 2 above.

I had posted the same question in a similar forum, but thought I'd get more insight in this regard:

Macro to open a Template and save a new workbook

Is this possible?

Thanks a lot guys