VBA GetFileName

1 Star2 Stars3 Stars4 Stars5 Stars (1 votes, average: 5.00 out of 5)

The FileSystemObject VBA GetFileName function returns the last component of a file or folder path except for the drive name. If a file path if given this will return just the file name. If a folder path is provided this will return the folder name.

VBA GetFileName Syntax

The path for which the file name or folder name is to be provided.

VBA GetFileName Examples

Simply the best place to learn Excel VBA