Automation Excel 'disable macro' prompt

[Guest]

How do I answer the disable macro prompt automatically when opening an Excel
workbook? We are using Excel 97 and 2002. In 2002 we want the Medium
security (prompt user) to safeguard against e-mail attachments... but our
..NET app needs to open as Read-Only and Disable Macros at all times. Is
there a way to answer these questions programatically before opening the
workbook?

I'm also looking for any good references on the Excel object model, as we
dont have any.
Thx,
troy

 

[Paul Clement]

¤ How do I answer the disable macro prompt automatically when opening an Excel
¤ workbook? We are using Excel 97 and 2002. In 2002 we want the Medium
¤ security (prompt user) to safeguard against e-mail attachments... but our
¤ .NET app needs to open as Read-Only and Disable Macros at all times. Is
¤ there a way to answer these questions programatically before opening the
¤ workbook?

No. You can change your Security Level to Low which will eliminate the warning dialog. The only
other alternative is to digitally sign your Excel documents.

¤ I'm also looking for any good references on the Excel object model, as we
¤ dont have any.

See if the following helps:

Understanding the Excel Object Model from a .NET Developer's Perspective
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odc_vsto2003_ta/html/ExcelObj.asp


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)