Property: ParentFolder for Folder

Property: ParentFolder for Folder

Returns the Folder object of the superordinate folder for a folder. You can use this to access the parent folder.

Set oFolder = Object.ParentFolder

The following example returns the superordinate folder of a file.

Function ShowParentFolder(sFolder)
  Dim fso, oMyFolder
  Set fso = CreateObject("Scripting.FileSystemObject")
  Set oMyFolder = fso.GetFolder(sFolder)
  ShowParentFolder = oMyFolder.ParentFolder
End Function