FileSystemObject : GetParentFolderName Method

Description: 

Returns the parent folder name.

Format : 

objectOfFileSystemObject. GetParentFolderName(filepath)

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

Arguments: 

• filepath
  • Mandatory
  • Type:     String
  • File path for which Parent Folder is to be return.

Function FnGetParentFolderName (strSpecificFilePath)

    Set fso = CreateObject("Scripting.FileSystemObject")

    strParentFolderName = fso. GetParentFolderName(strSpecificFilePath)    FnGetParentFolderName = strParentFolderName

End Function

Msgbox  FnGetParentFolderName ("c:\New Folder\file.txt")

Also Read:

1. FileSystemObject : FileExists Method
2. FileSystemObject : DriveExists Method
3. FileSystemObject : CreateTextFile Method
4. FileSystemObject : GetExtensionName Method
5. VBA-Excel: Add/Insert multiple objects from a folder in an Excel Document.