Learn Excel - Simplify Life with Excel Concepts

Excel ChDrive Function (VBA)

ChDrive Function VBA Code

How to use the ChDrive Function (VBA)

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


The Excel VBA ChDrive function allows you to change the current drive.


To changes the current drive.


The ChDrive function does not return any value, but rather changes the current drive.


ChDrive drive


The ChDrive function syntax has the following arguments:

  • drive: Required. The drive argument is a string expression that specifies an existing drive.
    • If "drive" is left blank, then the current drive is not changed.
    • If the drive argument is a multiple-character string, ChDrive uses only the first letter.


  • The ChDrive function changes only the current drive. Use the ChDrive function to change the current drive.

Useful Links: Link 1Link 2Link 3Link 4