dealing with attachments, this can be of some help :
You do not want to mess with already existing data, you do not want to
hard-code a path, and you are not sure that C:\ is always accessible...
The solution is to use Windows functions that provide you a path and a filename
that are safe to use.
Note : Windows clients only !
Paste this in your (declarations) section :
Declare Function GetTempFileName Lib "kernel32" Alias "GetTempFileNameA"
(Byval lpszPath As String, Byval lpPrefixString As String, Byval wUnique As
Long, Byval lpTempFileName As String) As Long
Declare Function GetTempPath Lib "kernel32" Alias "GetTempPathA" (Byval
nBufferLength As Long, Byval lpBuffer As String) As Long
Then in your code :
Const max_path_length = 255
prefixe$ = "tmp"
temp_file$ = String$(max_path_length, 0)
temp_path$ = String$(max_path_length, 0)
result = gettemppath(max_path_length, temp_path$)
temp_path$ = Left(temp_path$,result)
result = GetTempFileName (temp_path$, prefixe$ , 0, temp_file$)
If result <> 0 Then
temp_file$ = Left$ (temp_file$, Instr(temp_file$, Chr$(0)) - 1)
Else
Msgbox "Error : cannot get temporary file name"
Exit Sub
End If
temp_path$ contains the path
temp_file$ contains the finename (including the path)
as it is built using a prefix (which is "tmp", here) the result will look like :
"C:\WINDOWS\TEMP\tmp2301.TMP"
This was first published in November 2000