trying to do this in vbs - no go - creat dropdown list

[jloyzaga]

I'm trying to read an excel spreadsheet(SWW_TestFlow, Worksheet=Controller) and creating a dropdown list from all the cell values within a specific column("G").   

I would like to have the dropdown behave in such a way as to allow multiple selections and for all those selections to be written to a file.

I attached a file I started with to experiment with gui and controls etc but got totally lost.......

Can somebody help me?

Joe

multi-new.au3

[kcvinu]

I can't find a function named "_ExcelReadSheetToArray" in my copy of help file. I think you need to use _Excel_RangeRead function. Read help file.  

[JLogan3o13]

_ExcelReadSheetToArray is from the old version of Excel.au3: https://www.autoitscript.com/autoit3/docs/script_breaking_changes_excel_udf.htm

@jloyzaga I would suggest updating to the latest version of AutoIt, which will make working with Excel much easier for you.