Is there a way to refer to Query Tables by name instead of by index
number? Or is there a way to change the index numbers? I have a sheet
with a large number of querys and need to reference them individually,
preferably by name.

Dim oQT as Querytable
set oQT = Activesheet.QueryTables("MyQuery")

MyQuery being the name of the Querytable (modifiable in Properties)

works by me.

HTH
--
AP

a écrit dans le message de news:
...
Is there a way to refer to Query Tables by name instead of by index
number? Or is there a way to change the index numbers? I have a sheet
with a large number of querys and need to reference them individually,
preferably by name.

Thank you for the sanity check. Turns out this was just a reminder as
to why sleep is your friend after coding for too many hours straight.
Turns out I was forgetting the blasted underscore in the range name.
DOH!! :P