question

Upvotes
Accepted
d.f.gerritsen avatar image
5 ●0 ●0 ●1

Open Eikon for Excel through VBS script

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

eikoneikon-com-apivbscript
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

2 Answers

Upvotes
Accepted
Zhenya Kovalyov avatar image
4.6k ●26 ●7 ●22

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

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Upvotes
d.f.gerritsen avatar image
5 ●0 ●0 ●1

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

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Click below to post an Idea Post Idea