I currently extract historic data from Excel Eikon, which updates when the excel file has been opened. I am looking to automate this process, so I can prompt this excel to be update in the morning using VBS.
However, when I try to get this file to open, the set script doesn't update. Any help on how I can make this work? Or any alternative method I should be using for this?
Example of the data being extracted is: =RHistory("LCOc1",B1:C1,"START:01JAN05 NBROWS:3650 INTERVAL:1D",,"CH:In;Fd",B2)
There are numerous alternatives. You could create your own custom application eliminating the need to use Excel. You could replace RHistory worksheet function with RHistory API and perform all data retrieval in Excel VBA. You could use MACRO Refresh parameter in RHistory worksheet function to launch a macro when the function finished retrieving/refreshing the data. Whether any of this is a "better method" is totally subjective and solely depends on what criteria defines better method for you.