ChDrive Statement

Office 2013 and later
GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

Changes the current drive.

Syntax

ChDrive drive

The required drive argument is a string expression that specifies an existing drive. If you supply a zero-length string (""), the current drive doesn't change. If the drive argument is a multiple-character string, ChDrive uses only the first letter.

On the Macintosh, ChDrive changes the current folder to the root folder of the specified drive.

This example uses the ChDrive statement to change the current drive. On the Macintosh, "HD:" is the default drive name and ChDrive would change the current folder to the root folder of the specified drive. The following example assumes the machine actually has a drive named D.


                      ChDrive "D" ' Make "D" the current drive. 

Show: