Open Eikon for Excel through VBS script

d.f.gerritsen

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

Zhenya Kovalyov

@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.

d.f.gerritsen

Thanks Zhenya, I'll have a look at Python instead.