The GetFilesList function loops through a given folder, compares the file extension of each file against the given file extension, and returns a list of matching filenames.

Here's an intermediate function which can be called within the Do loop to check if the current filename has an appropriate Excel extension (i.e. instead of doing the comparison directly inside the GetFilesList function).

Continue Reading: Is that an Excel file I see? »