Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi, when I import external data into excel using the Tools Import
External Data .... function where does excel store this connection? I know it's there because i can right click and 'Refresh Data"..... I would like to access this connection some how but am not sure as how I go about doing so... Regards, jerm |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
It creates a query table object:
Dim WS As Worksheet Dim QT As QueryTable Dim QTCount As Long For Each WS In ThisWorkbook.Worksheets For Each QT In WS.QueryTables Debug.Print QT.Parent, QT.CommandText QTCount = QTCount + 1 Next Next MsgBox "There are " & QTCount & " query tables in this workbook." NickHK "jerm" wrote in message ups.com... Hi, when I import external data into excel using the Tools Import External Data .... function where does excel store this connection? I know it's there because i can right click and 'Refresh Data"..... I would like to access this connection some how but am not sure as how I go about doing so... Regards, jerm |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
thanks :)
jer NickHK wrote: It creates a query table object: Dim WS As Worksheet Dim QT As QueryTable Dim QTCount As Long For Each WS In ThisWorkbook.Worksheets For Each QT In WS.QueryTables Debug.Print QT.Parent, QT.CommandText QTCount = QTCount + 1 Next Next MsgBox "There are " & QTCount & " query tables in this workbook." NickHK "jerm" wrote in message ups.com... Hi, when I import external data into excel using the Tools Import External Data .... function where does excel store this connection? I know it's there because i can right click and 'Refresh Data"..... I would like to access this connection some how but am not sure as how I go about doing so... Regards, jerm |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel connection to ODBC database | Excel Discussion (Misc queries) | |||
Changing and Adding data through ODBC connection | Excel Discussion (Misc queries) | |||
ODBC connection string Excel to AS/400 | Excel Programming | |||
How to Switch the ODBC connection in Excel | Excel Programming | |||
Excel / Access ODBC connection | Excel Programming |