question

Upvotes
Accepted
23 1 0 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 5.0 MiB each and 10.0 MiB total.

Upvote
Accepted
39.2k 75 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 5.0 MiB each and 10.0 MiB total.

Upvotes
23 1 0 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 5.0 MiB each and 10.0 MiB total.

Click below to post an Idea Post Idea