I have a Visual Basic Script file (.vbs) that is scheduled to automatically start Excel, open an Excel file, and refresh the Thomson Reuters formulas in this file. However, when opening Excel through this vbs script, unfortunately the EIKON plugin is not loaded, so I'm not able to refresh the TR formulas. Is there any way to open Excel through this vbs script, and load the relevant plugins automatically so I can schedule this query?
@d.f.gerritsen this approach is generally not recommended. I suggest that you should have look at using COM, .NET or Python APIs for that purpose. Let me know if you require any assistance in deciding this.