Exported to Excel

[Martin]

Hi,

I have exported some files from my access database to
excel for use in a mail merge (long and complicated story
as to why) via a macro. What I would like to know is - is
it possible to delete this excel file once the macro is
finished, or at least wipe it clean for data protection
reasons?

Thanks for your help

Martin

 

[BerHav]

Hi Martin,

There is a VBA command available : Kill "Filename" where Filename can be
entered including drive and path.

Bernd