Get all files in a folder

NOTE: this post and the code it contains is still valid, however, it has been superseded by the 'Working with files and folders in VBA' post here https://www.thevbahelp.com/post/working-with-files-and-folders-in-vba.

This Function returns an array of Strings where each String is the name of a file in the specified folder ... it can include or exclude hidden files. This is another convenience function to simplify working with the VBA Dir function (and when you don't want or can't use the FileSystemObject) whenever you need to get a list of files.

Example usage:

Limitations: Windows only