VBA - Check If A Folder Exists
Discussing 6 VBA techniques and how they can be implemented in you project to validate the existence of a folder/directory:
• Dir Function
• File System Object (FSO) FolderExists Method
• GetAttr
• GetFileAttributesA
• PathFileExistsA
• Windows Management Instrumentation (WMI)
Then, later in the video, we look at some performance testing to see which techniques were the fastest, thus your best choice to use.
Article(s) on this Subject:
• https://www.devhut.net/vba%e2%80%93de...
Other Useful Resources:
Create Directory Structure/Create Multiple Directories/Create Nested Directories:
• https://www.devhut.net/vba-create-dir...
Detailed FSO Resource:
• https://www.devhut.net/vba-fso-files-...
Self-Healing Object Variable Resource:
• https://www.devhut.net/self-healing-o...
My Links:
• https://www.cardaconsultants.com/ (business)
• https://www.devhut.net/ (blog)