Syntax:
ExtractFilePath(Str)
Description:
Returns the drive and folder portions of a file name. The
resulting string is the leftmost characters of FileName, up to and including
the colon or backslash that separates the path information from the name
and extension. The resulting string is empty if FileName contains no drive
and folder parts.
Parameter Description
Str A text string containing the full path from which the path should be extracted.
Example:
Sub
Main
'will return c:\foldername
MsgBox
ExtractFilePath("c:\foldername\filename.txt")
End Sub
See Also: