Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
External data connections | Excel Worksheet Functions | |||
Data connections | Excel Discussion (Misc queries) | |||
Removing DATA Connections | Excel Discussion (Misc queries) | |||
Data Connections | Excel Worksheet Functions | |||
Data connections | Excel Discussion (Misc queries) |