Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |