Opening .xls, .xlsx, .xlsm with wildcard

[jlieu]

Hello, I have code that will open up a couple thousand excel files over the years one at a time and run some code. However, the extension has changed over the years. I was wondering is there a way to have excel open up all the different file types with variable file names. My guess so far is something along the lines of

'possibility 1: 
myExtension = "*.xlsm" Or "*.xls" or "*.xlsx"
'possibility 2: 
myExtension = like "*.xls"

'my ending code using extentions
myFile = Dir(myPath & myExtension)

 

[Joe4]

Just use "*.xl*"

 

[jlieu]

cool, it worked perfectly. Didn't know you can have a double ended wildcard. Thank you!