By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
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)
Msgbox "Error : cannot get temporary file name"
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 :