Error Messages With Data Dump

  • Thread starter Thread starter Keith
  • Start date Start date
K

Keith

I have a macro set up in my database that dumps data to
several Excel spreadsheets at once. This data dump will
take place weekly, replaceing the existing data in the
existing spreadsheet. My problem is that I have to click
"OK" on 30 different error messages that say "the excel
file Blah already exists. Do you wish to replace it?"
since I am dropping data into that many files.
I have already set the action SetWarnings to disregard all
system warnings, but I need to eliminate these error
messages that require input. How can I do that?
 
1. When you save the file is the action "save as" cause I
would think Save would just replace the file without that
error message.

2. Another (bad) option is to have all the fields linked
to a different file that you can have a macro erase and
then regenerate with the new information.

This may be a load of work for you though. And would slow
the excel files.
 
Back
Top