excel macro to delete file attachment from email after it was installed

[Alwinaz]

Hi there

Is there a way to destroy an excel file if it was send as an email attachment. I have a file Funmathicx.xlsm which i am sending via email. When the user open the file they will only see the instruction page and the rest of the worksheets are hidden. there is an install button on the sheet which creates a folder Funmathics under my documents and then save the file in that folder. Once it is saved i want a macro which will destroy (delete the file attachment) so that it can not be forwarded to other people. Is it possible to do something like this?

 

[Andrew Poulsom]

If you Google for 'remove email attachment vba' you will get lots of hits. You can use the Attachment's Delete or Remove method.

 

[Alwinaz]

Most of the post that i saw, gives vba that you put in you outlook. I am looking for vba to put in my excel file and not outlook.

 

[Andrew Poulsom]

You can automate Outlook from Excel but I don't know how you would find the Email that contained the attachment.

 

[Alwinaz]

So is it then not possible to write a macro/vba in excel to destroy/delete file content after running the install macro?

 

[Andrew Poulsom]

Not without knowing the Email that it came from.