Help referring to query tables by name
 

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.

Help referring to query tables 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.

Help referring to query tables 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