Suppress Excel Error Message in VB.NET Application

  • Thread starter Thread starter Fergus Cham
  • Start date Start date
F

Fergus Cham

Dear All,

I'm writing a VB.NET application to automate the process in Excel file.

I wanna know how to suppress the prompting of Excel Error Message and write
to logfile instead.

Thanks & Best regards,

Fergus
 
Hi,

The excel.application has a DisplayAlerts property which will
prevent excel from prompting the user.

Ken
 
¤ Dear All,
¤
¤ I'm writing a VB.NET application to automate the process in Excel file.
¤
¤ I wanna know how to suppress the prompting of Excel Error Message and write
¤ to logfile instead.
¤

You can use Ken's suggestion to eliminate the application specific dialog boxes but you will also
want to use Try...Catch to trap and handle the run time errors.


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