I am trying to loop through approximately 6 sheets that are connected to a Bloomberg terminal. From what I understand and have exhaustively read, is that Bloomberg cannot refresh a sheets data until the macro that triggers the refresh is exited. I have tried easily 15 permutations of the below code and have not been able to consistency have the data pulled down or "refreshed". Now, the below code is run in the middle of a much larger macro and I am not sure if that has anything to do with it's consistency. I know this is a tough question, because it does require a Bloomberg connection, so I hope I am able to find someone that can assist.

So essentially I am trying to refresh all sheets in a workbook that start with "BG_data*" and not refresh as in just activesheet.calculate, but a Bloomberg refresh, a refresh that brings new/updated data "down".

Thanks in advance!



Please Login or Register  to view this content.