Bypass Excel Macro warning when opening Excel spreadsheet

D

Dale Fye

I'm using automation to open an Excel workbook from Access. The workbook has
some macros in it that I want to disable. Is there a way, using automation,
to do this using the GetObject method, or some other method that may apply to
the Excel Application rather than the particular workbook?

I know I can just change the settings in the Tools -> Options, but not sure
how to actually do this programmatically.

Dale
 

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

Need Help with Macro Security 1
disable Excel AutoExec macro when opening via Access Automation 4
Enabling Macros message when NO macros in workbook 3
Bypassing the Security Warning when opening Excel file 5
Perl: opening Excel-Files 0
Want to have macro execute automatically when doc created 3
Linking text to photos 0
ASK Field Formatting 1

Top