Replace existing file

  • Thread starter Thread starter Brandi
  • Start date Start date
B

Brandi

I'm running a macro in access that then exports data into
various excel files. Is there any way the macro will
automatically tell access/excel to replace the existing
files. Every time it tries to save the data under that
same file name I have to click yes to replace the file.
Thanks.
 
Brandi,

I have the same problem. I have played arround with turning of the "SetWarnings", via the moacro, however it does not work correctly.

A workaraound is to create a batch file which would delete the required file before access is opened, and the macro is run.

*****************************************
* A copy of the whole thread can be found at:
* http://www.accessmonster.com/Uwe/Forum.aspx/access-macros/3334
*
* Report spam or abuse by clicking the following URL:
* http://www.accessmonster.com/Uwe/Abuse.aspx?aid=af4c6b0ea34b4c84980c9fb3edf3a975
*****************************************
 
Back
Top