VBA GetTempName

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

The FileSystemObject VBA GetTempName function returns a randomly generated available file path for a temporary file. No file is generated in this process however this is useful if temporary files need to be created quickly.

VBA GetTempName Syntax

VBA GetTempName Examples

The function is usually used to create temporary files e.g. using the VBA CreateTextFile method:

Simply the best place to learn Excel VBA