The Excel connector does not support interrogating Excel forms.  Opening password protected files is possible but then you are not able to use the connector to work with them.  You can run macros from the connector though - see below.

In My Excel-Form There is Dropdown also there,based on dropdown selection,macro generates some result.How can I perform that in my automation?

Hi Pravallika, 1) Create a windows adapter and set the exe path which should point to the excel.exe. 2) Open the windows adapters properties, set the childhookup property to "true" and StartMethod propert to "MonitorAll". 3) Start the windows adapter and manually launch the macro enabled excel file that you wanted to interrogate. Now you will be able to interrogate all the forms which are being triggerred by the macros. 4) If you are not able to interrogate with the bulls eye, then go to the windows-> list windows option in the windows adapter to identify the specific form thta needs to be interrogated. Hope this answered your question. Thanks, Sudheer

How can I overcome security warnings caused by a macro and activeX element in my Excel file when I open it with PegaRobotics? See screen shots attached.

This comment has been branched out as a new node and the new thread can be followed here