Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find the contents of a Connection property of the QueryTable objec
Greetings,
How can I determine the contents of Connection property of the QueryTable object in a Worksheet and if there are several queries in the same Worksheet?. Thank you in advance for your support. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find the contents of a Connection property of the QueryTable objec
hi,
finding querys: query tables show up as range names. so goto Insertnamesdefine if querytable are present, they will show up here. click on one and the range will appear in the box at the bottom. or you can use the navigator. in the upper left of the sheet, click the down arrow. the query range should be listed. click on one and it will take you to the query table. you must do this for each sheet. connection Property: click inside the query range and goto DateGet external Date edit query. (if the wizard comes up, toggle to the last page and click view data or edit query in Microsoft query.) when microsoft query comes up, click viewsql. this will be the connection. Regards Frank -----Original Message----- Greetings, How can I determine the contents of Connection property of the QueryTable object in a Worksheet and if there are several queries in the same Worksheet?. Thank you in advance for your support. . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find the contents of a Connection property of the QueryTable objec
Frank,
Thank you for the prompt response and the information you provided. I was hopping to get more information on how to accomplish this task programmatically. I have 480 Queries that I must modify regularly, which becomes a cumbersome task. "Frank Stone" wrote: hi, finding querys: query tables show up as range names. so goto Insertnamesdefine if querytable are present, they will show up here. click on one and the range will appear in the box at the bottom. or you can use the navigator. in the upper left of the sheet, click the down arrow. the query range should be listed. click on one and it will take you to the query table. you must do this for each sheet. connection Property: click inside the query range and goto DateGet external Date edit query. (if the wizard comes up, toggle to the last page and click view data or edit query in Microsoft query.) when microsoft query comes up, click viewsql. this will be the connection. Regards Frank -----Original Message----- Greetings, How can I determine the contents of Connection property of the QueryTable object in a Worksheet and if there are several queries in the same Worksheet?. Thank you in advance for your support. . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find the contents of a Connection property of the QueryTable objec
Dim ws As Worksheet
Dim qtbl As QueryTable For Each ws In ActiveWorkbook.Worksheets For Each qtbl In ws.QueryTables With qtbl Msgbox .Connection End With Next qtbl Next ws -- Dianne Butterworth SPYREN wrote: Greetings, How can I determine the contents of Connection property of the QueryTable object in a Worksheet and if there are several queries in the same Worksheet?. Thank you in advance for your support. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find the contents of a Connection property of the QueryTable o
Thank you Dianne,
This solution worked fine!. Thank you again for your response. "Dianne Butterworth" wrote: Dim ws As Worksheet Dim qtbl As QueryTable For Each ws In ActiveWorkbook.Worksheets For Each qtbl In ws.QueryTables With qtbl Msgbox .Connection End With Next qtbl Next ws -- Dianne Butterworth SPYREN wrote: Greetings, How can I determine the contents of Connection property of the QueryTable object in a Worksheet and if there are several queries in the same Worksheet?. Thank you in advance for your support. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 crashes after viewing property sheet in Data Connection | New Users to Excel | |||
Excel Connection to SQL 2007 can't find stored procedure message | Excel Discussion (Misc queries) | |||
always recheck data connection library for latest connection strin | Excel Discussion (Misc queries) | |||
Find OnAction property | Excel Programming | |||
How to check if SHEET has QUERYTABLE property ? | Excel Programming |