| 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 | |||
Linear Mode
