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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel TWO Instances of Excel One watching Other 3
Disable macro through automation 2
Importing any excel files with any sheet name into different tables in MSAccess using code 0
How to call Excel add-in macro from a button… 1
Access Access macro build gone wrong 0
Macro to copy value in field and insert it into filter 2
Diasabling Macro PopUp 5
Need to run a macro on opening a new excel file 0

Back
Top