GetOpenFilename Method VBA all types of Excel files

[daveyc18]

filefilter:="Excel files *.xlsx (*.xlsx),")

is there a way I can expand this to include, say, xls (old format), xlsb, xlsm, etc?

 

[Joe4]

Try:
Code:

filefilter:="Excel files *.xls* (*.xls*),")

or

filefilter:="Excel files *.xl* (*.xl*),")

 

[dmt32]

Hi,
try following & see if does what you want

FileFilter = "Excel 2003 (*.xls),*.xls," & _
              "Excel 2007 > (*.xlsx),*.xlsx," & _
              "All Excel Files (*.xl*),*.xl*," & _
              "All Files (*.*),*.*"

Dave

 

[daveyc18]

Try:
Code:

filefilter:="Excel files *.xls* (*.xls*),")

or

filefilter:="Excel files *.xl* (*.xl*),")

Try:
Code:

filefilter:="Excel files *.xls* (*.xls*),")

or

filefilter:="Excel files *.xl* (*.xl*),")

both work...tks!

 

[Joe4]

You are welcome!
Glad we could help.