VBA Automation or Using other applications Libraries Scripting File System Object
Example
Set createScriptingFileSystemObject = CreateObject("Scripting.FileSystemObject")
Tools> References> Microsoft Scripting Runtime
Associated DLL: ScrRun.dll
Source: Windows OS
MSDN-Accessing Files with FileSystemObject
The File System Object (FSO) model provides an object-based tool for working with folders and files. It allows you to use the familiar object.method syntax with a rich set of properties, methods, and events to process folders and files. You can also employ the traditional Visual Basic statements and commands.
The FSO model gives your application the ability to create, alter, move, and delete folders, or to determine if and where particular folders exist. It also enables you to get information about folders, such as their names and the date they were created or last modified.
MSDN-FileSystemObject topics: "...explain the concept of the FileSystemObject and how to use it."
exceltrick-FileSystemObject in VBA – Explained
Scripting.FileSystemObject
