How to use the ChDir Function (VBA)

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

SUMMARY:

The Excel VBA ChDir function allows you to change the current directory or folder.

PURPOSE:

To changes the current directory or folder.

RETURN VALUE:

The ChDir function does not return any value, but rather changes the current folder or directory on the current drive.

REMARKS:

• The ChDir statement changes the default directory or folder but does not change the default drive. A different statement, ChDrive, changes the default drive.
  
  
  
  
• On the Power Macintosh, the default drive always changes to the drive specified in path. Full path specifications begin with the volume name, and relative paths begin with a colon (:). ChDir resolves any aliases specified in the path:
  
  
  
  
• If "path" is left blank, then the default directory is changed on the current drive.
  

ChDir Function VBA Code example:

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

ChDir Function Example (as VBA code)

The ChDir function can only be used in VBA code in Microsoft Excel.

The following VBA code shows how the ChDir function used to change the current directory or folder on the current drive.

ChDir "C:\Pictures"

In the above VBA code example, ChDir "C:\Pictures" would sets the current directory to C:\Pictures.

VBA ChDir Function Error:

If you supply the invalid path to the ChDir function, you will get the error:
Run-time error '76': Path not found

---

---

Download Example Sample Excel File

ChDir-function-example.xlsm

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