Excel Interop to open excel with macros disabled

.net excel interop com-interop
Nishant picture Nishant · May 2, 2012 · Viewed 8.7k times · Source

Is there a way in C# to switch off macros in excel before loading an excel file. I am loading the excel file using Excel Interop. All I can see is solutions for VB.NET.

Thanks Nishant

Answer

John Koerner picture John Koerner · May 2, 2012

I think you can just set it on your Excel Application:

Excel.Application xapp = new Excel.Application();
xapp.AutomationSecurity = Microsoft.Office.Core.MsoAutomationSecurity.msoAutomationSecurityForceDisable;

Related questions

Excel get_Range missing when interop assembly is embedded in .NET 4.0

I build an assembly referencing a COM interop DLL. If I embed the COM interop types by setting Embed Interop Types to True in the Reference's properties (VS2010), at run-time an error occurs "object does not contain a definition for …

Read More
Clean up Excel Interop Objects with IDisposable

In my company the common way to release Excel Interop Objects is to use IDisposable the following way: Public Sub Dispose() Implements IDisposable.Dispose If Not bolDisposed Then Finalize() System.GC.SuppressFinalize(Me) End If End Sub Protected Overrides Sub …

Read More
Exception from HRESULT: 0x8002000B (DISP_E_BADINDEX) for System.Runtime.InteropServices.COMException

I have a part of code which tries to export data (from database) to Excel. When I am trying to perform this task, it is generating this error: System.Runtime.InteropServices.COMException occurred Additional information: Invalid index. (Exception from HRESULT: 0…

Read More