Override an existing file

[Talk_to_people]

I am trying to move files using a macro in Access. I create files weekly and
move to a shared folder. However, there is an error (File already exist) due
to the existing files. Is there a way I can override them? Thanks.

 

[Steve Schapel]

Talk,

No, sorry, this can not be done directly with a macro. If you use a VBA
procedure instead, you will be able to delete the existing file using
the Kill statement.

 

[Talk_to_people via AccessMonster.com]

Thank you.

Talk,

No, sorry, this can not be done directly with a macro. If you use a VBA
procedure instead, you will be able to delete the existing file using
the Kill statement.