Find QueryTable Name? 1

[ZoomDah]

I have 2 QueryTables and I need to call them one by one in my code.
How do I "call" those ?

Thanks

 

[PHV]

Something like this ?
For Each qt in ActiveSheet.QueryTables
qt.Refresh False
Next


Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[ZoomDah]

Can I call it separately like qt1 and at2 ?
What is the property, Name (like) ?

Thanks

 

[PHV]

You can call each separately, like this:
ActiveSheet.QueryTables("QueryName").Refresh True
To discover the "QueryName" you need, right click on each related range and choose Data ... properties.

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[ZoomDah]

Thanks so much
STAR