Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Queries created by MS Query not in QueryTables collection
On my spreadsheet I have created a table using an MS Query query, creating
the table via File/Return data to Excel. This creates a table in my worksheet and a connection that shows up in my existing connections dialog. I have no problems refreshing the table using the refresh button. However, in VBA this table does not show up in the Querytables collection for that worksheet when I print out the names of the items in the collection in the immediate window. Meanwhile, a connection created using the From Text button on the Data tab does show up. Does anyone have any insight as to why the MS Query does not show up, and how I can get it to show up? Otherwise, as far as I know, there is no way to manipulate it or refresh it via VBA. Thanks. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Queries created by MS Query not in QueryTables collection
How are you referening the collection? Are you starting the indexing at zero? Usually I get all the queries on the worksheet using the following for each qry in sheets("sheet1").queries msgbox("Query Name : " & qry.name) next qry -- joel ------------------------------------------------------------------------ joel's Profile: 229 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=183104 Microsoft Office Help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
viewing newly created access queries in excel via msquery | Excel Discussion (Misc queries) | |||
Works in Microsoft Query, but not with QueryTables | Excel Programming | |||
MS Query imbedded Queries | Excel Programming | |||
Locating Query Errors in a Sea of Queries | Excel Programming | |||
External data queries within applcation collection | Excel Programming |