I think my problem is similar to the above listed one, but I'm pretty new to VB and so didn't make too much sense of the replies - apologies if this is going back over old ground.
I have a spreadsheet that contains a macro that is intended to open up another sheet that contains a bunch of =blp Bloomberg formulas and then use that data in the first sheet. My problem is caused by the time lag on opening the 2nd sheet before the cells populate with data (they go to N/A and populate after something like 15-20 seconds). I can't figure out how to make the cells populate faster or the macro to wait for the data to come through.
First off I tried the VB Wait command, but that seems to pause everything, including the =blp formulas. I figure I need to use the DDEInitiate etc functions, but really aren't too sure how they work...
