Property: ParentFolder for File

Property: ParentFolder for File

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

Set oFolder = Object.ParentFolder

The following example returns the superordinate folder of a file.

Function ShowParentFolder(sFile)
  Dim fso, oMyFile
  Set fso = CreateObject("Scripting.FileSystemObject")
  Set oMyFile = fso.GetFile(sFile)
  ShowParentFolder = oMyFile.ParentFolder
End Function