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