Output to Excel

  • Thread starter Thread starter RFJ
  • Start date Start date
R

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
 
Use the "SendKeys" action. This will allow you to type in
the keystrokes (i.e.,"yes"{enter} to replace the file).
 
Back
Top