The Google link will probably exist for the forseeable future.
However, I am not sure I understand the question or the answer well enough to summarise it. We are not supposed post answers which are only links in case that link disappears and takes the answer with it.
I googled for BloombergUI.RefreshAllStaticData and was immediately taken to this Mr Excel page: Private Sub Populate_Me() Dim lRow_PM As Integer Public Sub Run_Me() 'Application.DisplayAlerts = False wb is a global-level workbook and ws1 is a global level worksheet. I've tried using a combination of DoEvents and Application.OnTime() to return control to the operating system and to get the program to wait for a long time for the data update, but neither worked. I want these values to appear while the program is still running. When I stop debugging - fully ending running the program - all the Bberg values that should have populated then appear. Because some of the functions are dependent on string and numeric field results being populated, the program hits a run-time error at that code. ' instead of the results of the query, no matter how slowly I go. When I step through the program it only displays '#N/A Requesting Data. Some additional functions' results are dependent on the first functions finishing and correctly displaying the Bberg data. The macro inserts Bloomberg functions into sheet1 that pull yield curve data.
I'm running a macro in a blank Excel 2007 workbook on a PC with a Bloomberg license.
0 kommentar(er)
