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. |
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 |
All times are GMT +1. The time now is 01:38 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com