Be the first user to complete this post

  • 0
Add to List

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 : GetDriveName Method
  2. FileSystemObject : GetExtensionName Method
  3. FileSystemObject : FileExists Method
  4. FileSystemObject : MoveFile Method
  5. FileSystemObject : GetFileVersion Method
  6. FileSystemObject : CreateFolder Method
  7. FileSystemObject in Excel Macro
  8. FileSystemObject : CreateTextFile Method