Visual Basic for Applications Reference
Returns the last component of specified path that is not part of the drive specification.
The GetFileName method syntax has these parts:
|object||Required. Always the name of a FileSystemObject.|
|pathspec||Required. The path (absolute or relative) to a specific file.|
The GetFileName method returns a zero-length string ("") if pathspec does not end with the named component.
Note 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.