Multiple filters for Excel files in OpenFileDialog

Does anyone know how to display both *.xls and *.xlsx files in the OpenFileDialog method of NotesUIWorkspace? Have tried:

var = uiws.OpenFileDialog(True, [title$] , “Excel Workbook|.xls|Excel Workbook|.xlsx” , [initialDirectory$])

… but only the first type is shown in the dialog.

Subject: Multiple filters for Excel files in OpenFileDialog

You will have to select the Second “Excel Workbook” option from the drop down below the file name text box in the dialog window, to get the xlsx files.

Subject: Multiple filters for Excel files in OpenFileDialog

Each filter has to be unique both in name and alias, so if You change the filter to this:

“Excel Workbook | .xls | Excel 2007 Workbook|.xlsx”

then It will show both type of files in the dialog.

hth

Subject: Multiple filters for Excel files in OpenFileDialog

Thanks - it works :slight_smile: