Macro to open a Template and save a new workbook

[Keibri]

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.

Is this possible?

Thanks a lot guys !

[AstroZelda]

Hello,

of course it's possible, I dit it just a few days ago

First I need to know if you launch the copy macro from another workbook than the one you want to copy.
If it is the case, you don't have to open the said workbook.

Here is a sample of how you can do this :

Please Login or Register  to view this content.

There you go ! Just tell me if it works or not, or if you don't understand something !

François

[Keibri]

Hi AstroZelda thanks for your message. I am having some problems with the last line of the code, i.e. "FileCopy strTemplateFullName strCopyFullName"- cause it is giving me an error.

If it is not too much of an inconvenience, could you kindly guide me accordingly

Thanks a lot

[Norie]

Why not specify the template in Workbooks.Add?

Please Login or Register  to view this content.

[Keibri]

Cheers!! That solved it out neatly!!!

Thanks a lot !!

[AstroZelda]

I forgot to write "As String" after the last variable, it may be what's causing the trouble. Otherwise, this method works fine for me ^^
I'm glad you could solve your problem with Norie's solution, and sorry mine didn't work for you

BTW, @Norie I didn't know you could set a template when using workbook.add, I am definitely keeping that method !

Have a good day folks !

[Keibri]

Thanks for the follow up AstroZelda