Hello all,
I have a macro that is creating a new email and sending attachment to Person A.
Person A then is supposed to open the attachment, click approval button. Approval button is an Activex Control, which puts “APPROVAL” word into specific cell and then send the file to Person B.
PROBLEM: attachment in email from Person A to Person B doesn’t have word APPROVED
ISSUE: sending file that is not saved, therefore word APPROVED is not there
SOLUTION I USED: I used ThisWorkbook.Save, to Save the file in Temp and then file is being sent to Person B.
PROBLEM WITH SOLUTION: file is saving in Documents folder and also I do not need this file. When I tried to delete the file I am getting an error that I cannot access the Path/File
QUESTION: How to Save a File in Specific location like “My Documents”, then send it (I have this part of code) and then delete the file? I do not want approvers to store the files.
Part of the code:
I have a macro that is creating a new email and sending attachment to Person A.
Person A then is supposed to open the attachment, click approval button. Approval button is an Activex Control, which puts “APPROVAL” word into specific cell and then send the file to Person B.
PROBLEM: attachment in email from Person A to Person B doesn’t have word APPROVED
ISSUE: sending file that is not saved, therefore word APPROVED is not there
SOLUTION I USED: I used ThisWorkbook.Save, to Save the file in Temp and then file is being sent to Person B.
PROBLEM WITH SOLUTION: file is saving in Documents folder and also I do not need this file. When I tried to delete the file I am getting an error that I cannot access the Path/File
QUESTION: How to Save a File in Specific location like “My Documents”, then send it (I have this part of code) and then delete the file? I do not want approvers to store the files.
Part of the code:
Code:
Range("D77").Value = "REVIEWED by " & Application.UserName
ThisWorkbook.Save
On Error Resume Next
With OutlookMail
End With
On Error GoTo 0
Set OutMail = Nothing
Set OutApp = Nothing
