I'm trying to run some code that saves over an exisiting file using VBA in Access, but I don't want to have to keep clicking yes everytime so I can fully automate.

Is there a way to turn off/disable the Excel Save As/File Already Exists prompt??