Expand Minimize

ChDir Statement

Last modified: December 06, 2011

Applies to: Office 2013 | VBA

Changes the current directory or folder.

Syntax

ChDir path

The required path argument is a string expression that identifies which directory or folder becomes the new default directory or folder. The path may include the drive. If no drive is specified, ChDir changes the default directory or folder on the current drive.

Remarks

The ChDir statement changes the default directory but not the default drive. For example, if the default drive is C, the following statement changes the default directory on drive D, but C remains the default drive:

ChDir "D:\TMP" 

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:

ChDir "MacDrive:Tmp" ' On the Macintosh. 

Note that when making relative directory changes, different symbols are used in Microsoft Windows and on the Macintosh:

ChDir ".." ' Moves up one directory in Microsoft Windows. 
ChDir "::" ' Moves up one directory on the Macintosh.

This example uses the ChDir statement to change the current directory or folder. On the Macintosh, the default drive name is "HD" and portions of the pathname are separated by colons instead of backslashes. Similarly, you would specify Macintosh folders instead of \Windows. Finally, wildcard characters have no special meaning on the Macintosh and are treated simply as characters.

' Change current directory or folder to "MYDIR". 
ChDir "MYDIR" 
 
' Assume "C:" is the current drive. The following statement changes 
' the default directory on drive "D:". "C:" remains the current drive. 
ChDir "D:\WINDOWS\SYSTEM" 

Show:
© 2014 Microsoft