Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I'm using the following query to loop through each embedded ODBC query
in each worksheet in the workbook. Dim TargetFile As Workbook Dim ws As Worksheet For Each ws In TargetFile.Worksheets For Each qt In ws.QueryTables qt.Connection.name Next qt Next ws I'd like to know where the query is embedded (cell address location of the query). How do I do this? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Unwanted Querytable Autofilter on ODBC Import | Excel Programming | |||
Using Dynamic Cell Address As Formula Location | Excel Worksheet Functions | |||
Cell Address Location | Excel Worksheet Functions | |||
ODBC / OLE DB QueryTable Editor Add-In for Excel | Excel Programming | |||
Using =address to provide address location for =average | Excel Worksheet Functions |