outputting to Excel, need to delete existing spreadsheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I use macros and the OutputTo command to create spreadsheets and reports.
What is the command to have the macro erase/overwrite the existing file?
When I run it using the switchboard menu, it does not ask to replace the
existing file.
 
Pam,

You can use a VBA procedure instead of a macro, which provides the Kill
command to delete the existing file before running a DoCmd.OutputTo method.
 

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

Remove prompt for replacing file 5
Macro SetWarnings (Access 2003) not working 2
Output File Naming 8
access 2007 output table to csv 2
Help! My Macro is Freezing my Database! 6
Copying Query into Excel spreadsheet 1
Custom menus by macros 3
'OutPut To' Excel without prompt to overwrite 4

Back
Top