Gar,

If the VBA form is being ran strictly by the excel.exe, there isn't much we can do in the way of interrogating the form controls. Pega Robotics is limited in how we in integrate with Microsoft Office Suite programs and their components.

Robotics is provided an excel connector among other connectors to integrate with Microsoft programs. All interrogation attempts with Microsoft products are limited to outer form interrogation.

If there is another sub process to the Excel executable, you may need to attempt setting that process as the path instead of excel to see if you are able to interrogate the inner form controls that way. 

Another alternative approach would be the use of send keys. You could possibly send the necessary keyboard commands through the interrogated form to navigate to each of the text fields (i.e. TAB, Enter, DOWN and UP}.

Once you are in location of one of the fields, you can use sendkeys again to emulate manual typing. Below is a link that goes into detail of the use of sendkeys through automation.

http://help.openspan.com/80/Adapters_Interrogation/SendKeys_Method.htm

http://help.openspan.com/80/Adapters_Interrogation/Key_Codes_for_Sendkeys_Method.htm

--Zach