Disable macros in Excel

  • Thread starter Thread starter Scott Wallace
  • Start date Start date
S

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
 
Try setting EnableEvents = false at the application level. That should work
for you.
 
Back
Top