Disable macros in Excel

[Scott Wallace]

Anyone know how to disable macros when access an Excel file through
automation? I have an Excel file that fires macros when it is opened. I
need to automate reading values from the file through a VB.NET service -
can't change the source Excel files. I can't seem to find a way to either
globally disable macro execution or a property through the automation. Any
ideas?

Thanks,
Scott

[Scott Glasgow]

Re: Disable macros in Excel

Try setting EnableEvents = false at the application level. That should work
for you.


"Scott Wallace" <john@doe.com > wrote in message
news:ulMKga0kDH A.2160@TK2MSFTN GP10.phx.gbl...[color=blue]
> Anyone know how to disable macros when access an Excel file through
> automation? I have an Excel file that fires macros when it is opened. I
> need to automate reading values from the file through a VB.NET service -
> can't change the source Excel files. I can't seem to find a way to either
> globally disable macro execution or a property through the automation.[/color]
Any[color=blue]
> ideas?
>
> Thanks,
> Scott
>
>[/color]