I have this line of code that enables me to filter excel files only
Code: Select all
.Filters.Add "Excel Files (*.xls; *.xlsx; *.xlsm)", "*.xls; *.xlsx; *.xlsm", 1
so the list should be `Excel Files` and `xls` and `xlsx` & `xlsm`
Code: Select all
.Filters.Add "Excel Files (*.xls; *.xlsx; *.xlsm)", "*.xls; *.xlsx; *.xlsm", 1
Code: Select all
.Filters.Add "Excel Workbooks (*.xlsx)", "*.xlsx"
.Filters.Add "Excel Macro-Enabled Workbooks (*.xlsm)", "*.xlsm"
.Filters.Add "Excel Binary Workbooks (*.xlsb)", "*.xlsb"
.Filters.Add "Excel 97-2003 Workbooks (*.xls)", "*.xls"
Code: Select all
.Filters.Add "Excel Files", "*.xls; *.xlsx; *.xlsm"