How to use the MkDir Function (VBA)

This Excel tutorial explains how to use the Excel MkDir function with syntax and examples using VBA.

SUMMARY:

The Excel VBA MkDir function allows you to creates a new directory or folder.

PURPOSE:

To create a new folder or directory.

RETURN VALUE:

The MkDir function does not return a value, but rather creates a new folder or directory.

REMARKS:

• If the specified folder or the directory already exists, the function returns an error.
• This function will not create multiple subfolders.
• If you want to create subfolders you must create the top level folders first and then create the subfolders with a subsequent procedure call.

MkDir Function VBA Code example:

Diffrent way to use the MkDir function using Excel VBA Code...

MkDir Function Example (as VBA code)

The MkDir function can only be used in VBA code in Microsoft Excel.
The following VBA code shows how the MkDir function used to get the attribute values of an path.

MkDir "C:\My\TestFiles"

In the above VBA code example, The directory called TestFiles would be created under the C:\My.

VBA MkDir Function Error:

If the path is already exists, you will get the error:
Run-time error '75': Path/File access error

---

---

Download Example Sample Excel File

MkDir-function-example.xlsm

Useful Links: Link 1… Link 2… Link 3… Link 4…