VBAやVBSでテンポラリファイル取得

Dim FSO As Object, TempName As String
Set FSO = CreateObject("Scripting.FileSystemObject")
With FSO
    TempName = .GetSpecialFolder(2) & "\" & .GetBaseName(.GetTempName) & ".xlsxx"
End With
Set FSO = Nothing

ネタ元

• http://officetanaka.net/excel/vba/filesystemobject/sample05.htm