hello forum,
i'm using the Application.GetOpenFilename to call the browse window.
i would need to set the filter to display all the excel 2003 files *.xls AND excel 2007 files *.xlsx.
i found the code to alternately display xls or excel, but i want only these 2 types of files to be displayed at once.
here is the code
i'm using the Application.GetOpenFilename to call the browse window.
i would need to set the filter to display all the excel 2003 files *.xls AND excel 2007 files *.xlsx.
i found the code to alternately display xls or excel, but i want only these 2 types of files to be displayed at once.
here is the code
Code:
FileFilters = "Excel 2003 Files (*.xls),*.xls," & _
"Excel 2007 Files (*.xlsx),*.xlsx,"
Application.GetOpenFilename(FileFilters)