<div>
When I understand you correctly: That's normal. <br />
<br />
A template is &quot;generated&quot; when you save an Excel document by saving it as template. When opened in Excel it behavces like a &quot;normal&quot; workbook.
</div>


<div>
Its working after setting editable = true!!
</div>


<div>
<div class="content wysiwyg-content">
I am facing the issue while opening an Excel macro-enabled template(.xltm) file when I open from my application.<br />
<br />
I have gone through this &quot;<a href="http://stackoverflow.com/questions/21850650/issue-with-excel-template-fileswhich" rel="ugc">http://stackoverflow.com/questions/21850650/issue-with-excel-template-fileswhich</a>&quot;&nbsp; tells how the .xltm file opens. Here I want to override the orignal .xltm file so I need to open the same in .xltm format programatically in c#.<br />
<br />
Below is code used to call the Workbooks.Open.<br />
<br />
`Globals.ThisAddIn.Applica<wbr />tion.Workb<wbr />ooks.Open(<wbr />DisplayFil<wbr />e, false, false, Type.Missing, &quot;&quot;, &quot;&quot;,<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing,<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Type.Missing, 0)`<br />
<br />
However, it opens the file in Excel in .xlsx format only.<br />
<br />
Need suggestions on what needs to be changed in calling the 'Workbooks.Open' method or any other method can be used.
</div>
</div>


I am facing the issue while opening an Excel macro-enabled template(.xltm) file when I open from my application.

I have gone through this "http://stackoverflow.com/questions/21850650/issue-with-excel-template-fileswhich"  tells how the .xltm file opens. Here I want to override the orignal .xltm file so I need to open the same in .xltm format programatically in c#.

Below is code used to call the Workbooks.Open.

`Globals.ThisAddIn.Application.Workbooks.Open(DisplayFile, false, false, Type.Missing, "", "",
                                Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing,
                                Type.Missing, 0)`

However, it opens the file in Excel in .xlsx format only.

Need suggestions on what needs to be changed in calling the 'Workbooks.Open' method or any other method can be used.

.xltm file opens as .xlsx file

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

Microsoft Office

C# is an object-oriented programming language created in conjunction with Microsoft’s .NET framework. Compilation is usually done into the Microsoft Intermediate Language (MSIL), which is then JIT-compiled to native code (and cached) during execution in the Common Language Runtime (CLR).