Excel VBA: Check If File or Folder Exists (DIR) – Open File or Create Folder

Excel VBA Tutorials

Use the DIR function in Excel VBA to check if a file or a folder exist. You can then decide what to do if they exist. For example you can open the Workbook to copy values from and then close the workbook.

Credit Leila Gharani