Bloomberg BDH Refresh Via Macro Loop Application.Ontime

Hi,

Firstly you don't need to know anything about Bloomberg to answer this query, only that Bloomberg has various functions that take time to update.

The code Application.Run "RefreshEntireWorkbook" will update these functions but Application.OnTime (Now + TimeValue("00:00:25")), "RunList" is required to allow them time to get the data from the feed. However this only works if the refresh and wait commands are in a seperate function. So in simplified terms it must go like this in vba:

Please Login or Register  to view this content.

BUT I want to do this operation within a loop (see my code below). So what I want is a way to call the refresh sub-rountine and then go back to where the call was made with the count variable holding the same value as before. Now it is the Runlist part of Application.OnTime (Now + TimeValue("00:00:25")), "RunList", Count that calls back to the main routine and I have tried to send the Count. This is where I am stuck. Basically I want to know how to use Application.Ontime to send the Count Variable and a GoTo instruction,

Cheers,

Martin

---------------------------------------------------------

Please Login or Register  to view this content.

thank you for posting your resolution

I had been working on this (seemingly easy) issue for hours !

Thanks a lot for posting, you made my day !