Opening only xlsx files

Hi All,

My current code will open and compile all my required cells to a Master document and all works fine until I come across another file type, my problem is I need to only open files of a xlsx type, my current code will try to open any file beginning with PJ, even a doc file, how can I alter to code to only open xlsx files?

Please Login or Register  to view this content.

Hi Roy

This is Code I use

Please Login or Register  to view this content.

Hello RoyLittle0,

You should always post the complete Sub or Function code. It can then be easily copied to a workbook and examined for errors, tested, etc.

Hello RoyLittle0,


Thanks for filling the code. It makes a big difference in what you want to do.

Do You need to check all subfolders as well or just a certain depth of subfolders, like the only folders in the main folder?

Hi Leith

Yes I need to check all sub-folders, there will be nothing in the main folder with the exception of sub-folders, but the sub-folders could be 6 deep in places but at least 5 folders to search

I thing the folder structure is something like this.
Main Folder - Country/Sales Support Unit - Company - Year - Machine Type