Excel ODBC Data Connection
 

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

Excel ODBC Data Connection
 

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

Excel ODBC Data Connection
 

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