Hi

I'd like to add a new worksheet to the existing active workbook based on a template (.xltx). I can add a new workbook with

Excel.Application.Workbooks.Open("path");

but this opens a new window. How can I load the template into the active book?

Thanks

It seems to be no method for direct loading template into workbook. You can open template and then copy worksheet into your workbook.

Excel.Application.Sheets.Add(Type:="TemplateWorkbookPath")

You can do it from your workbook variable that you are currently working in:

wkb.Application.Sheets.Add(Type:="TemplateWorkbookPath")

Thanks Jon49 it works!

I was just doing a reply, but you beat me to it! For anyone that looks at this in the future this is how it should be done in .NET:

That's how you would type it in VBA. Sorry, I should have put it in .NET for you.

Excel.Application.Sheets.Add(Type.Missing,Type.Missing, Type.Missing, "TemplateWorkbookPath")

I'm not sure what would be the equivalent of Type.Missing in C#, that is in VB.