Wait time but without freezing (time to dowload data in cells)

[bryan444]

Hi

I'd like to know if you guys have a solution to just make a pause without freezing excel
It is in order to download in cells with the Bloomberg function data before copying them as you can see in this code
With this code, Excel stops working instead of downloading the data

Please Login or Register  to view this content.

here is the file (but you wont see the data because you probably won't open the file from a Bloomberg equipied machine ;-)
https://docs.google.com/open?id=0B1X...nRDOW5HRndCWms

Best regards



R

[bryan444]

I tried with this but it puts an error...

Please Login or Register  to view this content.

[Sindhus]

You can try this out.

Put this declaration on top of all the modules.

Please Login or Register  to view this content.

Wherever you want to pause, use this code

Please Login or Register  to view this content.

replace 5000 with milliseconds you require.

[bryan444]

THanks

but with sleep I'm affraid excel stops working, so the data is not being downloaded... :-(

[Sindhus]

how about using doevents in for loop? This will allow other programs to run.