Automating Excel WorkBook Suppress Excel Message Boxes Possible?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

unemotionalhumanoid - 27 Aug 2003 23:45 GMT

I am writing an application that gets data from excel worksheets, it works
fine for most workbooks but when I open some by using the following line of
code:

_xlApp = new Excel.ApplicationClass();

Excel.Workbook WorkBook1 = _xlApp.Workbooks.Open(FilePath,0,true, 5,"",
"", true, Excel.XlPlatform.xlWindows, "\t", false, false, 0, false, false,
false);

Excel produces a message box saying:

Microsoft Office Excel recalculates formulas when opening files last
saved by an earlier version of excel (Yes / NO / Cancel)

Is there any way to suppress these annoying message boxes?

Thank you

Reply to this Message

Scott Glasgow - 28 Aug 2003 17:30 GMT

Try _xlApp.DisplayAlerts = false;

> I am writing an application that gets data from excel worksheets, it works
> fine for most workbooks but when I open some by using the following line of
[quoted text clipped - 14 lines]
>
> Thank you

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...