By using vba.booksticle.com you agree to our cookie policy, We and our partners operate globally and use cookies, for multiple purposes

948 Steps to 6 Figures by Learning Excel-VBA and Other Skills

Step 340 - Creating a folder

Use the MkDir "folder name" to create a new folder

The directory will be created in the Active Directory which can be determined with the CurDir() statement.

To set the proper starting point you have to use ChDir "name" command.

Do the following in the

Immediate Window

Chdir "C:\Temp"
MdDir "New Dir"

Go to File Explorer and check that the directory was created