delete after OutputTo

  • Thread starter Thread starter mate
  • Start date Start date
M

mate

I have a macro that sends the output of a table to an
excel spreadsheet. Is there a way to have all the records
in that table deleted after the outputTo? I don't want to
delete the table though. any help would be great.
thanks, mate.
 
Mate
Create a delete query that deletes * from that table. and set the macro to run tha
query right after your outputto
Will

----- mate wrote: ----

I have a macro that sends the output of a table to an
excel spreadsheet. Is there a way to have all the records
in that table deleted after the outputTo? I don't want to
delete the table though. any help would be great.
thanks, mate
 
Back
Top