GetOpenFilename

[StevenM]

Please Login or Register  to view this content.

The above code works, but I can't figure out how to get both *.xlsx files and/or *.xls files.

I've tried: sFilters = "Excel Files (*.xls;*xlsx), *.xls;*.xlsx"
But I get all files and not just Excel files.

I've tried: sFilters = "Excel Files (*.xlsx), *.xlsx" & "Excel Files (*.xls), *.xls"
But I get an error with that method.

Any idea how I can get both *.xls & *.xlsx files?

Any help will be greatly appreciated!

Steven Craig Miller

[tigeravatar]

StevenM,

Give this a try:

Please Login or Register  to view this content.

[StevenM]

Thanks! An asterisk both before and after does the trick!

[tigeravatar]

You're very welcome, and thank you for the rep