This video displays how to get various file names from any folder into an excel spreadsheet. This process is made easier by enabling the Scripting Runtime Library under Tools/References within the VBA editor window. This allows access to easy to use VBA methods that are specific to file system objects such as Files, Folders, etc. All of this is covered in this video.
Learn More about Excel VBA & Macros with this Book on Amazon:
amzn.to/3xnqT6R
Get a Microsoft Office 365 Personal Subscription with this Amazon link:
amzn.to/3aV9GtL
DISCLAIMER: As an Amazon Affiliate I get a commission for every purchase via these links.