ChDrive Statement
Changes the current drive.
Syntax:
ChDrive Text As String
Parameters:
Text: Any string expression that contains the drive letter of the new drive. If you want, you can use URL notation.
The drive must be assigned a capital letter. Under Windows, the letter that you assign the drive is restricted by the settings in LASTDRV. If the drive argument is a multiple-character string, only the first letter is relevant. If you attempt to access a non-existent drive, an error occurs that you can respond to with the OnError statement.
Example:
Sub ExampleChDrive
ChDrive "D" ' Only possible if a drive 'D' exists.
End Sub