问题描述
我正在使用VBA处理Excel电子表格.我有一个Bloomberg BDH函数，我想从VBA刷新.我尝试录制宏，然后单击Bloomberg-> Refresh Workbooks按钮，但是宏显示为空.如何从代码中做到这一点?我正在使用Excel 2007，但发现输入的一种选择
I am working on an Excel Spreadsheet with VBA. I have a Bloomberg BDH function that I want to refresh from VBA. I tried recording a macro and clicking the Bloomberg->Refresh Workbooks button but the macro came up empty. How can I do this from code? I'm using Excel 2007 and I found one option of entering
应用程序.运行"blpmain.xla！RefreshAllStaticData"
但是找不到blpmain.xla.我不确定这是什么版本的Excel/BBG-Addin.
Application.Run "blpmain.xla!RefreshAllStaticData"
but blpmain.xla can't be found. I'm not sure what version of Excel/BBG-Addin this was for.
有帮助吗?
推荐答案
我最终要做的是在适当的范围内重新粘贴Bloomberg公式.这迫使数据重新下载.不是最理想的解决方案，但它可以工作.
What I ended up doing was re-pasting down the bloomberg formulas in the appropriate ranges. This forced the data to redownload. Not the most ideal solution but it works.
这篇关于单击Bloomberg Ribbon上的RefreshWorkbook的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！