How to delete external file?

[Shirley]

Need your help...

I exported tables to excel and emailed it to my client. I
need to go to the next record and take the same action.
The excel file's name is the same. If I don't delete it
before processing the next, The previous tabs will stay.
Plus, I'd like to delete it to keep the harddrive clean.
But I haven't figured a way to do it ...

Thanks,

Shirley

 

[Cheryl Fischer]

Hello Shirley,

If you are using VBA code to do your processing, you can use the
"ever-popular" Kill statement to delete external files. For example:

Kill "c:\MyApp\Orders.XLS"