Macro to Refresh Bloomberg Data, Wait Until Data Is Refreshed

[jregan89]

Hey guys,

I've scoured the internet looking for a solution here, and there are actually a lot of posts on this problem but I haven't found a solution for mine. I'm not vastly experienced with VBA, but I understand a decent amount. Appreciate any help in advance!

Basically what I have is a spreadsheet set up to pull Bloomberg data (a finance portal, they have an excel add-in that brings in market data) for a given stock ticker, populate a few charts for it, and then print out a nicely formatted sheet. I'm doing this for about 200 tickers, so I've been trying to set up a macro that will copy/paste new tickers from a list that I have put together... then my hope is that I could have the sheet refresh and print them all out, so I'd have a nice stack of 200 printouts (one on each company) waiting for me.

The problem is, when I try to do this code, it is taking the ticker from my sheet called "Macro" and pasting it into the right place in the sheet "Data." However, it is printing out the sheet when everything is still "N/A" trying to refresh the data... so what I get is a stack of 200 printouts with blank charts (ha).

Here's My Code:

Please Login or Register  to view this content.

[jregan89]

Cleaned the code up a little so it is easier for you all to read, but same problem exists

Please Login or Register  to view this content.