question

Upvotes
Accepted
martin.becker avatar image
23 ●3 ●1 ●2

RtGet returns 0-values when Excel Workbook opened via Powershell Script

Hello All,

We have a couple of Excel workbooks we have to open on a daily basis. In order to automate things we want to open the workbooks at a scheduled time with the help of a Powershell script. As the current version of the script opens multiple Excel workbooks in separate instance we have the problem that RtGet() functions only retrieve 0-values for any field for all but the first workbook that is opened. When the workbook is opened by the Powershell script I can't see what is missing for the Thomson Reuters Add-In to function properly. When opening the workbooks manually quotes are received as expected. What could cause the retrieval problems and how can I make this work?


Thank you

eikoneikon-com-api
icon clock
10 |1500

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

pimchaya.wongrukun01 avatar image   pimchaya.wongrukun01

Hello @martin.becker

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

2 Answers

· Write an Answer
Upvote
Accepted
Alex Putkov.1 avatar image
39.4k ●77 ●11 ●27

One scenario where the behavior you describe may be observed is if the workbook is opened in a new instance of Excel before Eikon Excel COM add-in finished loading. Since Excel does not provide an indicator when the COM add-in finished loading, if you must open a workbook in a new instance of Excel, you may need to add an arbitrary wait period in your Powershell script to allow Eikon Excel COM add-in to fully load before opening the workbook.

icon clock
10 |1500

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

Upvotes
martin.becker avatar image
23 ●3 ●1 ●2

It seems that did the job. Thank you

icon clock
10 |1500

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

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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