Hello all, I use this site all the time and can usually find the help I need without having to post a question. I have the code to auto run a macro after a query refresh, but my problem is that it wont work with multiple queries. Dim X As New Class1 Sub Initialize_It() Set X.qt = Thisworkbook.Sheets(1).QueryTables(1) End Sub This is the initialize code that I think is causing the problem. Can someone help me figure out how to make this work with multiple queries? Thank you

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Trying to auto run macro after MULTIPLE query refreshes

Thread starter Krashnss
Start date Sep 4, 2014

Krashnss

New Member

Sep 4, 2014

Hello all, I use this site all the time and can usually find the help I need without having to post a question. I have the code to auto run a macro after a query refresh, but my problem is that it wont work with multiple queries.

Code:

Dim X As New Class1

 Sub Initialize_It()
  Set X.qt = Thisworkbook.Sheets(1).QueryTables(1)
 End Sub

This is the initialize code that I think is causing the problem. Can someone help me figure out how to make this work with multiple queries? Thank you