Can you query status of data connections?
 

Hi

Is it possible to determine if data connections are disabled or not in Excel
2007 VBA?

E.g. if I run this VBA

ActiveWorkbook.Worksheets("sheet1").Range("B2").Qu eryTable.Refresh
BackgroundQuery:=False

Err.number is always 0 even if data connections are disabled. I would like
to check and prompt a warning message if the data connectios are disabled.

Many thanks