Web data query automatic refresh - specifying when background refresh has finished

[Jondar]

I have the following code so it automatically refreshes all my external web data queries (background refresh) of my entire Workbook when I run this Macro every 2 minutes in a loop.

Please Login or Register  to view this content.

But how do I specify so that this Macro is run not every 2 minutes exactly, but run immediately after the background refresh has finished, in a loop (as in, imagine that refreshing any given webpage in Internet Explorer does not always take the exact amount of time every time I do so).

[FDibbins]

This is a VBA question, I will move it to that forum for you

[Jondar]

Anyone? :s