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.Applica
tion.Workb
ooks.Open(
DisplayFil
e, 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.