|
Be the first user to complete this post
|
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:
- FileSystemObject : DriveExists Method
- Excel-VBA : Insert Multiple Images from a Folder to Excel Cells
- FileSystemObject : CopyFile Method
- FileSystemObject in Excel Macro
- FileSystemObject : GetAbsolutePathName Method