Visual Basic for Applications Reference
Returns a randomly generated temporary file or folder name that is useful for performing operations that require a temporary file or folder.
The optional object is always the name of a FileSystemObject.
The GetTempName method does not create a file. It provides only a temporary file name that can be used with CreateTextFile to create a file.