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
 
Top