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)