VBA: Dir() for multiple file types?

[cineno]

I have a loop that's opening all workbooks in a directory using Dir("*.xls"). However, some files may be Excel 2007, so I also want it to open ".xlsx" files. Is there an easy way to change the Dir() call to open files of both types?

Thanks for any help!

 

[Case_Germany]

Hi,

Mmmhhh... try - Dir("*.xl*")?

Case_Germany

 

[cineno]

Thanks!

That got it.