Note: FSO can only be used in Excel 2000 and later versions.

FileSystemObject makes it easy to work with files and folders while keeping the code clean and short. While some of the things mentioned above can also be done using traditional VBA functions (such as the DIR function) and methods, that would lead to longer and more complicated codes. I will cover all these above examples (plus more) later in this tutorial.

Get a list of all the file names (or sub-folder names) in a folder.

Using it, you can access and modify the files/folders/directories in your computer system.įor example, below are some of the things you can do by using FileSystemObject in Excel VBA:

Example 6: Copy All Files From One Folder to AnotherįileSystemObject (FSO) allows you to access the file system of your computer.

Example 5: Copy a File from One Place to Another.

Example 4: Get the List of All Sub-folders in a Folder.

Example 3: Get a List of All Files in a Folder.

Example 2: Create a New Folder in the Specified Location.

Example 1: Check if a File or Folder Exists.

Setting the Reference to the Microsoft Scripting Runtime Library.What All Objects Can You Access Through FileSystemObject?.

Enable vba in excel 2016