Hi all,

At the moment I have a code that will open files based on prefix + wildcard search and paste it into my master spreadsheet.

The problem which I cannot solve after searching online is that it doesn't go based on 'Name' order when opening the spreadsheets in this specific folder.

I also want a msgbox to come up to say how many rows of data there is in each of these spreadsheets (excluding the headings) to complete this code.

Thanks!

Please Login or Register  to view this content.