FileSystemObject : GetDriveName Method

Description: 

Returns drive name, corresponding to the file name.

Format : 

objectOfFileSystemObject. GetDriveName(filepath)

• objectOfFileSystemObject : As the names says, it’s a FileSystemObject.

Arguments: 

• filepath
  • Mandatory
  • Type:     String
  • filepath , whose parent drive to be return.

Function FnGetDriveName (strFilePath)
      Set fso = CreateObject("Scripting.FileSystemObject")
      strDriveName = fso. GetAName (strFilePath)     
      FnGetDriveName = strDriveName

End Function

Msgbox FnGetDriveName ("c:\NewFolder\file.txt")

Output : C

Also Read:

1. Excel-VBA : Insert Multiple Images from a Folder to Excel Cells
2. FileSystemObject in Excel Macro
3. FileSystemObject : FolderExists Method
4. FileSystemObject : MoveFile Method