Ignore excel vba errors during read cell values from C# through COM interop

Question

I am running VBA macros from C# which can yield errors. These errors are characterized by a pop-up prompting for debugging, interrupting the application and requiring user input. I need these macros and they cannot be disabled.

How I can ignore these errors or close dialogs automatically?

Answer 1

Ör in the most simplest easiest way. Include on error resume next in your macros,so that the macro wont stop at errors.