Excel Add-in having templates

[mdgabe]

I created a nice add-in that is used by my colleagues, I also created a two tab template that is used by my colleagues. Is there a way to put the template inside my add-in, so when the user selects that option, it would insert the two tab template inside the active workbook?

 

[ThomasLafferty]

Sure something like:

Sub InsertTemplateSheets()
    Workbooks.Open Filename:="[!]TemplateFileNameAndPathHere[/!]"
    Sheets("[!]TemplateSheet1[/!]").Copy Before:=Workbooks("Book1").Sheets(1)
     Sheets("[!]TemplateSheet2[/!]").Copy Before:=Workbooks("[!]Book1[/!]").Sheets(1)
    Windows("[!]TemplateFileName[/!].xls").Activate
    ActiveWindow.Close
End Sub

You will need to change the items in red to match your actual situation.
Hope this helps.
Tom

Born once die twice; born twice die once.

 

[mdgabe]

That's good if you wanted to distribute the add-in and the template separately, but I want to bundle them together, so the template sheets are within my add-in. Is that possible?
Thanks for your prompt reply!
Mike