Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
where do my SQL querries get stored in the MS query tool in excel?
I am not sure what happened but when I right click on my tables to edit my
querry I am getting a bunch of errors and I cannot open the MS query tool. Where are my SQL queries stored? (please for the love of god tell me in the spreadsheet somewhere) -- Neall |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
where do my SQL querries get stored in the MS query tool in excel?
Look up the VBA Help for the QueryTable object and CommandText
Sub ListQTs() Dim ws As Worksheet, qt As QueryTable On Error Resume Next ' ignore errors getting SQL CommandText For Each ws In ActiveWorkbook.Worksheets For Each qt In ws.QueryTables Debug.Print qt.Name, qt.Connection Debug.Print vbTab, qt.CommandText Next Next End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stumped on establishing web querries on MS Excel | Excel Discussion (Misc queries) | |||
ADO: run a stored Access query from Excel | Excel Programming | |||
How to execute parametrised stored procedure from MS query? | Excel Programming | |||
calling a stored access query from excel vba | Excel Programming | |||
Problem Code: Retrieving Stored Access 03 Query | Excel Discussion (Misc queries) |