VBA to Get the File Path and folder path - VBA for file picker and folder picker

Scan your folders with Excel VBA by using Dir()

VBA to Extract File Name and File extension from File Path - Get File Information in Excel

VBA code for Filedialog(to select the file,folder path dynamically)

VBA Loop Through All Files in a Folder

Excel VBA Macro: List All Files (From a Selected Folder)

Excel 2010 VBA Tutorial 96 - Searching for Files using FileSystemObjects

(Microsoft Excel VBA) How to Check Files and Folders

Excel VBA Macro: Extract Data from All Files in a (User Selected) Folder