Refresh Queries From Userform

mjschukas · May 15th 2007

Refresh Queries From Userform...

i would like to refresh a query from a user form (query is in another worksheet)...?

(i have tried the following, but with error...)

Code

Worksheets("data_material").QueryTables.Refresh

thank you...

carlmack · May 15th 2007

Re: Refresh Queries From Userform

QueryTables is a collection a bit like Worksheets. So you need to specify the name of the query table.

eg.

Code

ThisWorkbook.Worksheets("Sheet1").QueryTables("Q1").Refresh

If you right click the QT and select the properties you should be able to change the name to something simple.

You may also wish to switch off the background refresh in case the user double clicks. You could code it like :-

Code

Dim QT As QueryTable
Set QT = ThisWorkbook.Worksheets("Sheet1").QueryTables("Q1")
QT.BackgroundQuery = False
QT.Refresh

HTH
Carl

Participate now!