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

On Mon, 9 Aug 2004 15:47:01 -0700, "Troy" <(E-Mail Removed)> wrote:

¤ 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/de...l/ExcelObj.asp


Paul ~~~ (E-Mail Removed)
Microsoft MVP (Visual Basic)