how to pick up xlsx and xls extension from Subfolders

[Ninjataktikz]

I have a code that picks up xls extension from subfolders and displays them. But I also need to add XLSX extension how will I do that. Also the code that I have right now. removes the .xls part in drop down it would be great if .xlsx is also removed.

Here's the code that I have right now.

Please Login or Register  to view this content.

Thanks.

[JBeaucaire]

Maybe:

Please Login or Register  to view this content.

[Ninjataktikz]

Maybe:

Please Login or Register  to view this content.

Hi thanks for responding I understand that part but here's my problem how do I deal with this. Because that part of the code is connected to this. How will I implement it here so it takes both xls and xlsx files. Please see red / Bold font Thank you..

Please Login or Register  to view this content.

[JBeaucaire]

I think you've designed yourself into a corner. The first macro I believe is gathering file names for you.... but then you intentionally strip off the extension, then this next macro is trying to use your "stripped" filenames and put the extension back on? No offense, but that's funny.

So, fix your original macro to create your list of "found files" with extensions intact. Then just open them.