Excel VBA: Check If File or Folder Exists (DIR) – Open File or Create Folder April 2, 2021 neha sharma Excel 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 Please support our Sponsors here :