Public Declare Function GetTempPath Lib "kernel32" Alias "GetTempPathA" (ByVal nBufferLength As Long, ByVal lpBuffer As String) As Long
Use as follows:
Dim sDir As String
Dim lBuf As Long
Dim lReturn As Long
lBuf = 100
sDir = Space$(lBuf)
lReturn = GetTempPath(lBuf, sDir)
If lReturn = 0 Then
sDir = App.Path
Else
sDir = Left$(sDir, lReturn)
End If