View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
unemotionalhumanoid unemotionalhumanoid is offline
external usenet poster
 
Posts: 1
Default Automating Excel WorkBook With C# Suppress Excel Message Boxes Possible?

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 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