Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Refresh Bloomberg data in an excel file from a script
HI,
I run a vb script which loops through excel files, and runs excel macros to update data from a database. What I would like to happen is for the excel files to have their Bloomberg data refreshed, before the script runs (or be refreshed by the script). Running a macro with the below line does refresh the Bloomberg data. Application.Run "RefreshEntireWorkbook" But when I run this macro from a script, it does not work. Does anyone know of a way to refresh Bloomberg data in an excel file from a script ? Regards, Tom |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Refresh Bloomberg data in an excel file from a script
On Nov 23, 10:36*pm, Tom wrote:
HI, I run a vb script which loops through excel files, and runs excel macros to update data from a database. What I would like to happen is for the excel files to have their Bloomberg data refreshed, before the script runs (or be refreshed by the script). Running a macro with the below line does refresh the Bloomberg data. Application.Run "RefreshEntireWorkbook" But when I run this macro from a script, it does not work. Does anyone know of a way to refresh Bloomberg data in an excel file from a script ? Regards, Tom You don't say how you are getting the bloomberg data. send your file to dguillett1 @gmail.com |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Refresh Bloomberg data in an excel file from a script
On Nov 25, 12:20*am, Don Guillett wrote:
On Nov 23, 10:36*pm, Tom wrote: HI, I run a vb script which loops through excel files, and runs excel macros to update data from a database. What I would like to happen is for the excel files to have their Bloomberg data refreshed, before the script runs (or be refreshed by the script). Running a macro with the below line does refresh the Bloomberg data. Application.Run "RefreshEntireWorkbook" But when I run this macro from a script, it does not work. Does anyone know of a way to refresh Bloomberg data in an excel file from a script ? Regards, Tom You don't say how you are getting the bloomberg data. send your file to dguillett1 @gmail.com- Hide quoted text - - Show quoted text - Thanks Don, but from our correspondance, I think we are on different wavelengths. Does anybody else have a solution to this problem ? Regards, Tom |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Refresh Bloomberg data in an excel file from a script
hi Tom,
have you try, Application.Run "blpmain.xla!RefreshAllStaticData" -- isabelle |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Refresh Bloomberg data in an excel file from a script
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Script to refresh data and save and close | Excel Programming | |||
Create folder, text file and vbs script from data in excel | Excel Programming | |||
refresh data from a intermediate excel data file (not opened) | Excel Programming | |||
Refresh Imported Data - Does the Excel file have to be open? | Excel Discussion (Misc queries) | |||
How to auto-refresh Pivot data when open Excel file? | Excel Worksheet Functions |