how to get the return value from excel builtin methods

hi,

I am using the below code in my excel vba.

Please Login or Register  to view this content.

I want to check from the program whether the refresh worked correctly. i just want to know whether it pops up error because of invalid username and password. i saw in the link http://msdn.microsoft.com/en-us/library/microsoft.office.interop.excel.odbcconnection.refresh.aspx .

If the refresh method didnt completed correctly then the method 'refresh' returns false. how can i assign that return value to a boolean variable.

i tried like

Please Login or Register  to view this content.

it throws the compile error as type mismatch.


please help me how to check whether refresh method works correctly.

I think the documentation about this instruction is not consistent and/or correct

You could try creating a separate function with error handling

Please Login or Register  to view this content.

This function should return true in case of any errors, but without displaying warnings, unless ODBC generates one