Web Query to Trigger Macro

[eforti]

Hello All,
I am running a series of web queries in my workbook, which update every 5 minutes or so. I'd like to run a macro after each query to help with data management. Could someone please explain how this might be done? I already have the macro created, just don't know how to call it to open with an event.

Thanks in advance

 

[John_w]

See XL2000: How to Use the Query BeforeRefresh and AfterRefresh Events

It shows this code:

Dim X As New Class1

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

I haven't done this, but for multiple web queries (QueryTables) I think you would have to use an array or collection of Class1 objects, and loop through all QueryTables (in each sheet if they are in different sheets) to initialise each Class1 object.

 

[eforti]

John_w,
Thanks for the response. This looks a little more complicated than some of the stuff I've tried in the past, but I'll have to read through your link to see how to tackle it.