Unable to read dropdown values from Excel VBO

[Anonymous]

Hi All, We have a excel which has few VBA dropdown controls and few text boxes. When we try to read the excel into a collection using MS Excel VBO, we are getting the values present in text boxes but the values which are in the dropdown controls are not being read. We tried spying the excel application using different modes as well without success. Please help! Thanks, Ankit

[Anonymous]

Excel to collection will have one to one Row values, If a row has drop down in excel blue prism cannot read those values.if drop down values are few and hard coded u can store those drop down values in separate collection which can be created manually and Manipulate as per your requirement. If it is large in number and not hard coded you can launch Excel.exe as an object and read those drop down after spying particular Row (Textbox).

[Denis__Dennehy]

I think you will need to experiment with the other actions and utility objects available to you. The get worksheet actions effectively use copy all and parsing logic to quickly get the data. I presume this method does not work for your VBA controls. Your other options are to get field values individually (which would be slow), create your own Excel code action that does work with your VBA controls, and maybe experiment with saving your Excel in a different format such as CSV and reading that data in using one of the CSV actions available in another object.