Update connection CommandText

[mateoc15]

I have a standard table (not a pivot table) with a related external connection to SQL Server. Everything executes fine if I give a query defined from the GUI but I'm having trouble updating it to run dynamically.

I tried

ThisWorkbook.Connections("my connection name").ODBCConnection.CommandText = "my sql"

but I get "Object doesn't support this action".

If I iterate through the QueryTables collection in that sheet it has no query tables, despite the fact that I see one right in front of me on sheet 1! I even added a second one to make sure and the collection is still empty.

I'm in the right scope (not in another workbook or anything)

Any idea why the QueryTables collection would be empty?

Thanks!

[mateoc15]

Bump? Surely this is easier than I'm making it.