彭博-刷新工作簿如何调用 [英] Bloomberg - Refresh Workbook how to call

问题描述

我想知道是否有办法做:

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

Bloomberg - > Refresh Workbook

但不能用我的手和VBA或其他方式使用..:

But not with my hand and in VBA or using something else.. :

Workbook.calculate 有时在公式获取#N/A正在请求数据... 时不起作用，因为未按时加载数据.

Workbook.calculate does not work some times formula gets #N/A Requesting Data... because Data aren't loaded on time..

我真的需要找到一种100％可行的方法来做到这一点，否则，如果有时失败可能会是一个巨大的问题

I really need to found a 100% working way to do it, else if it fail sometimes it can be a huge problem

推荐答案

您可以在Bloomberg加载项中使用以下过程

You can use the following procedures in the bloomberg add-in

Application.Run "RefreshCurrentSelection"

Application.Run "RefreshEntireWorksheet"

Application.Run "RefreshEntireWorkbook"

Application.Run "RefreshAllWorkbooks" 

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

对于 CurrentSelection ，您必须先选择所需的数据

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

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

这篇关于彭博-刷新工作簿如何调用的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！