From Excel VBA help file:
<TABLE id=topTable width="100%"><TBODY><TR id=headerTableRow2><TD align=left>
GetFileName Method</TD></TR></TBODY></TABLE>
Description
Returns the last component of specified path that is not part of the drive specification.
Syntax
object.
GetFileName(pathspec)
The
GetFileName method syntax has these parts:
<TABLE><TBODY><TR><TH>Part</TH><TH>Description</TH></TR><TR><TD>
object</TD><TD>Required. Always the name of a
FileSystemObject.</TD></TR><TR><TD>
pathspec</TD><TD>Required. The path (absolute or relative) to a specific file.</TD></TR></TBODY></TABLE>
Remarks
The
GetFileName method returns a zero-length string ("") if
pathspec does not end with the named component.
<TABLE><TBODY><TR><TH>
Note</TH></TR><TR><TD>The
GetFileName method works only on the provided path string. It does not attempt to resolve the path, nor does it check for the existence of the specified path.</TD></TR></TBODY></TABLE>