<div>
What happens with above code?
</div>


<div>
If it is a .xlsm it doesn't load my add-in. I have to go into the Option Add-ins section and select COM Add-ins then re-check the box to make it available as the system unchecks this.
</div>


If it is a .xlsm it doesn't load my add-in. I have to go into the Option Add-ins section and select COM Add-ins then re-check the box to make it available as the system unchecks this.

<div>
<div class="content wysiwyg-content">
Hi<br />
<br />
I have quite a complicated add-in the causes strange errors if i open Excel by opening <br />
a .xlsm file. I need to determine if the ActiveWorkbook is a .xlsm file.<br />
How do I do this?<br />
<br />
&nbsp; &nbsp; Private Sub ThisAddIn_Startup() Handles Me.Startup<br />
<br />
&nbsp; &nbsp; &nbsp; &nbsp; If Globals.ThisAddIn.Applicat<wbr />ion.Active<wbr />Workbook.F<wbr />ileFormat.<wbr />ToString &lt;&gt;&nbsp;&quot;52&quot; Then<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; oAddInStartUp()<br />
&nbsp; &nbsp; &nbsp; &nbsp; End If<br />
<br />
&nbsp; &nbsp; End Sub
</div>
</div>


Hi

I have quite a complicated add-in the causes strange errors if i open Excel by opening 
a .xlsm file. I need to determine if the ActiveWorkbook is a .xlsm file.
How do I do this?

    Private Sub ThisAddIn_Startup() Handles Me.Startup

        If Globals.ThisAddIn.Application.ActiveWorkbook.FileFormat.ToString <> "52" Then
            oAddInStartUp()
        End If

    End Sub

Excel Add-in VB.net - determine if active workbook has macros

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

Visual Basic .NET (VB.NET) is an object-oriented programming language implemented on the .NET framework, but also supported on other platforms such as Mono and Silverlight. Microsoft launched VB.NET as the successor to the Visual Basic language. Though it is similar in syntax to  Visual Basic pre-2002, it is not the same technology,