https://community.blueprism.com/t5/Product-Forum/Unable-to-read-dropdown-values-from-Excel-VBO/m-p/68777#M21382 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 Tue, 23 May 2017 14:20:00 GMT Anonymous 2017-05-23T14:20:00Z https://community.blueprism.com/t5/Product-Forum/Unable-to-read-dropdown-values-from-Excel-VBO/m-p/68777#M21382 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 Tue, 23 May 2017 14:20:00 GMT https://community.blueprism.com/t5/Product-Forum/Unable-to-read-dropdown-values-from-Excel-VBO/m-p/68777#M21382 Anonymous 2017-05-23T14:20:00Z https://community.blueprism.com/t5/Product-Forum/Unable-to-read-dropdown-values-from-Excel-VBO/m-p/68778#M21383 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). Tue, 23 May 2017 15:09:00 GMT https://community.blueprism.com/t5/Product-Forum/Unable-to-read-dropdown-values-from-Excel-VBO/m-p/68778#M21383 Anonymous 2017-05-23T15:09:00Z https://community.blueprism.com/t5/Product-Forum/Unable-to-read-dropdown-values-from-Excel-VBO/m-p/68779#M21384 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. Tue, 23 May 2017 15:09:00 GMT https://community.blueprism.com/t5/Product-Forum/Unable-to-read-dropdown-values-from-Excel-VBO/m-p/68779#M21384 Denis__Dennehy 2017-05-23T15:09:00Z