VBA - File System Object (FSO) | Dealing with files Folders and Subfolders.
FileSystemObject (FSO) allows you to access the file system of your computer. Using it, you can access and modify the files/folders/directories in your computer system.
For example, below are some of the things you can do by using FileSystemObject in Excel VBA:
Check if a file or a folder exists.
Create or rename folders/files.
Get a list of all the file names (or sub-folder names) in a folder.
Copy files from one folder to another.
I hope you get the idea.