Code Bug Fix: Bloomberg – Refresh Workbook how to call

Original Source Link

I would like to know if there was a way to do :

Bloomberg - > Refresh Workbook

enter image description here

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

enter image description here

Application.Run "RefreshCurrentSelection"

enter image description here

Application.Run "RefreshEntireWorksheet"

enter image description here

Application.Run "RefreshEntireWorkbook"

enter image description here

Application.Run "RefreshAllWorkbooks" 

enter image description here

Application.Run "RefreshAllStaticData"    
Application.Run "RefreshData"

For the CurrentSelection you would have to select the desired data first

ThisWorkbook.Worksheets("Sheet1").Range("YourData").Select
Application.Run "RefreshCurrentSelection"

Tagged : / /

Leave a Reply

Your email address will not be published. Required fields are marked *