delete after OutputTo

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.
 
W

Willy

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Delete all data after a symbol in a field 0
OutputTo Then SendObject 3
Dealing with a Pivot Table (when I don't want to) 0
Macro to select and delete levels of a document 2
Output File Naming 10
How do I dynamically name tables using a list of values 0
Using OutputTo to generate report output by overwriting existing file 0
Can OutputTo Overlay an existing file? 9

Top