VBA for Error Handling

[rhmkrmi]

Hi there,

Do you know how I can use Error Handling in VBA to create a pop-up message for the end user when the connection cannot be refreshed due to disconnection from the database?

The error that Excel produces is like: [DataSource.Error] ODBC: ERROR [HY000] and so on.

Thank you.

 

[Joe4]

Does it give you an error number?
If so, then it is easy to capture it in error handling.

 

[rhmkrmi]

Yes, it gives me error codes IM006 and HY000 in the same message.

Thank you.

 

[Joe4]

Hmmm... those aren't typical error codes.
Do you get this error when you run VBA code, or sometime else?
If it is when you run the VBA code, can you post the code?

 

[rhmkrmi]

I am running an SQL and I get this message when the refresh fails because there is no connection to the database.
I am using ODBC and run a query in SQL to dynamically refresh values in Excel.

 

[Joe4]

So, you aren't running any VBA when this error occurs?
You typically add error handling code to VBA code where the error occurs.
If the error is not happening due any VBA code running, then there is nothing to add error handling to.

If you can check the connection via VBA code, then perhaps you could add code to the Workbook_Open event (which runs when the workbook is first opened), to check to see if the connection works. If you can come up with the VBA code to check the connection, we can help add error handling to that code.