VB Code to delete a file

[JahJr]

I have the following code that creates a file.

Please Login or Register  to view this content.

this code is used to create a file that is attached to a email. After the email is sent I need code to delete the file. I tried working with
Kill
but could not get it figured out.

[Greg M]

Hi there,

Assuming you haven't changed either the current directory or the active worksheet since creating your temporary file, the following code should delete the temporary file:

Please Login or Register  to view this content.

Hope this helps - please let me know how you get on.

Regards,

Greg M

[shg]

The code can't be executing in the workbook that is ultimately deleted, because you have to close it before you kill it.

[JahJr]

Worked great

[Greg M]

Hi again,

Many thanks for your feedback - I'm glad I was able to help.

Regards,

Greg M