error handler ODBC/dataconnections?

[pallar]

Hi!

Can u make an code for handling errors in the dataconnections?

I have a Excel workbook, with a ontime makro that at the moment "refreshs" all dataconnections each 10 minutes. It collect data from different workbooks..
But some times one of the workbooks that are connected are being edited while my makro runs witch calls for an error.. Could this be avoided?

Like an regular errorhandler. But for Query links, that simply "dont update the link" if there is an error.

sub refresh() 
 
On error go to errH
 
thisworkbook.refreshall
 
errH:
end sub

But obviously i found out this dont work for Query links..

So could this be done? And please how?

Thx alot