outputting to Excel, need to delete existing spreadsheet

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

Steve Schapel

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

Macro SetWarnings (Access 2003) not working 2
Custom menus by macros 3
export to Excel 1
Copying Query into Excel spreadsheet 1
Overwriting files 9
Specifiy Tab on Ouput to Excel 2
Output to Excel 1
TransferSpreadsheet macro, to Overwrite data not Append To Bottom 3

Top