Open only .xls files in a given directory using macro

[ldsone]

Just wondering... I have a piece of code - a macro in excel that allows me to open files in a given directory. The thing is that I only want to open .xls files, and the code that I have opens all the files in a given directory.

Can anyone help me with this matter.

Thanks.

Please Login or Register  to view this content.

I have posted the thread on those sites as well:
http://stackoverflow.com/questions/1...ry-using-macro
http://www.excelforum.com/excel-prog...14#post3318314

[Norie]

Add a check on the file extension.

Please Login or Register  to view this content.

[ldsone]

Thanks a million... Works perfectly...