VBA to delete file

[Ian]

I'm using VBA to create and format and Excel spreadsheet from the data in an
Access database. The code then goes on to attach the spreadsheet to an
email. What code do I need to delete the file from the hard disk once it is
attached?

 

[Douglas J. Steele]

The VBA command to delete a file is Kill

 

[Ian]

Simple, but effective.

Many thanks, Douglas.