Exported to Excel

  • Thread starter Thread starter Martin
  • Start date Start date
M

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
 
Hi Martin,

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

Bernd
 
Back
Top