Hi,
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?
Thanks, Dirk
@d.f.gerritsen
Thank you for your participation in the forum. Is the reply below satisfactory in resolving your query? If yes please click the 'Accept' text next to the reply. This will guide all community members who have a similar question. Otherwise please post again offering further insight into your question.
Thanks,
-AHS
@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.
The problem that you describe is not specific to the Thomson Reuters Excel add-in, and is discussed here and here for example.
