Changes the current drive.
RTrim (Text As String)
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.
Sub ExampleChDrive ChDrive "D" ' Only possible if a drive 'D' exists. End Sub