Question

"ExcelApplicationWorkBooks" Property Usage

Hi guys,

While exploring Excel Connector's properties, i have found the property named "ExcelApplicationWorkBooks". I figured out that this property is used to get a list of work books associated with the connector.

My question is how to associate multiple workbooks to the Excel connector so that we can use the property "ExcelApplicationWorkBooks" to get a particular workbook.

Thanks in advance.

Comments

Keep up to date on this post and subscribe to comments

Pega
July 19, 2019 - 11:44am

A given connector is associated with only one workbook. I suspect that this property is part of the underlying COM object that the component wraps. Using the Excel Connector component, you can only open one-at-a-time with a given connector.

Pega
July 31, 2019 - 6:53am

We cannot associate multiple excel books to excel connector by this. The Excel connector can work with a single workbook at a time .This property is a reference to the Microsoft Excel workbook object. We can take out the proxy of this and use methods like GetItem to get an active excel workbook object and use that in automation.