The magic sauce here is the DIR function. If you're not familiar, think of DIR as the VBA equivalent of the old-school Windows command prompt DIR command. It checks the file system and tells you ...