Check Folder Existence Using VBA in Excel (Free UDF)
Before a macro creates, deletes or saves into a folder, you should check folder existence using VBA. If the folder is missing, the macro stops with a run-time error. If
Tag: Folder
File System Object in VBA: Get Files Information in Excel
The File System Object lets Excel VBA read a folder and bring the details of every file into a worksheet: the file name, the file type, the size in KB