I would like to know if there was a way to do :
Bloomberg - > Refresh Workbook
But not with my hand and in VBA or using something else.. :
Workbook.calculate does not work some times formula gets
#N/A Requesting Data... because Data aren’t loaded on time..
I really need to found a 100% working way to do it, else if it fail sometimes it can be a huge problem
You can use the following procedures in the bloomberg add-in
Application.Run "RefreshAllStaticData" Application.Run "RefreshData"
CurrentSelection you would have to select the desired data first
ThisWorkbook.Worksheets("Sheet1").Range("YourData").Select Application.Run "RefreshCurrentSelection"