Determine the drive, folder & file existence (VBA functions)

Determine the drive, folder & file existence (VBA functions)

26 January 2014

The File System Object (FSO) provides access to a computer's file system. The particular object contains 3 object collections, 4 other objects, as well as several properties and methods.

This post focuses on accessing three useful properties of the File System Object using VBA:

  • Drive Exists.
  • Folder Exists.
  • File Exists.