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

martin.becker

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

Alex Putkov.1

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.