How to refresh/load RTD Bloomberg function (BDH) in excel in vba

Question

I would like to know if there's a way in VBA code forcing the bloomberg functions (In spreadsheet) to update its value( Any BDH functions) Targeting Developers have faced similar issue/ have Bloomberg terminal What have I tried-- ``` Application.RTD.RefreshData Application.RTD.throttleInterval = 0 Application.CalculateFull ``` The BDH function do not reload themselve. The only way I can refresh them now is : I click the "Refresh WorkBook" Button on the Ribbon of the BloomBerg add-in. Since the Bloomberg Add-in is locked in VBE, I cannot find out the necessary code. Am I missing any Bloomberg Reference? Can any Bloomberg expert/user point me in the right direction? Thanks.

Accepted Answer

I did a searching of the keyword "refresh" in the xla by opening it in notepad. Found the following targets:

```
RefreshAllWorkbooks
blpmain.xla!RefreshAllStaticData
blpmain.xla!'RefreshWorkbookFundamentalsData
blp.xla!IsBlpRefreshAvailable
```

I tried them out one by one, the first 2 works by calling:

```
Application.run "RefreshAllWorkbooks"
Application.run "RefreshAllStaticData"
```

But not calling them alone ( I guess it's because I somehow can call protected PUBLIC procedure using Application.run)

```
RefreshAllWorkbooks
```

or

```
RefreshAllStaticData
```

Thanks for all the help

How to refresh/load RTD Bloomberg function (BDH) in excel in vba

Solution

Problem