Output to Excel

[RFJ]

I've got a macro that uses seven access reports to update seven
spreadsheets. However, I have to use the keyboard to overcome the message
"myfilename.xls already exists. Do you want to overwrite the existing
file." - seven times

I always want to overwrite any existing file so is there something I can do
in the macro for it to be done automatically.

TIA

Rob

 

[Guest]

Use the "SendKeys" action. This will allow you to type in
the keystrokes (i.e.,"yes"{enter} to replace the file).