prompting to select a =>2007 excel file

[drom]

Hi and Thanks in advance!

I am trying to prompt a user for a Excel file eg: .xlsm or .xlsx

but using:

vFxName1 = Application.GetOpenFilename(FileFilter:="All Excel Files (*.xl?*), *.xl?*", Title:="Select Excel Files")
vFxName2 = Application.GetOpenFilename(FileFilter:="All Excel Files (*.xl??), *.xl??", Title:="Select Excel Files")

does not work, any idea?

Thanks!

 

[dave3009]

Try just use xls* without the ? question mark.

 

[drom]

I have tryed that as well, but does not work!
vFxName = Application.GetOpenFilename(FileFilter:="Excel Files (*.xls*), *.xls*", Title:="Select a excel file)

 

[shg]

... FileFilter:="Excel Files, *.xlsx;*.xlsm", ...