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??
Printable View
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??
Moved To Office Development
What are you using? Excel VBA or Access VBA?
The code to turn off the notifications is difference between the two and what works in one, won't work in the other.
I am running vba code in Access to open transfer a query to excel file, run excel macro, so the code needs to turn off the excel piece that is saving the file over the exising one. So Excel VBA is what I need, if possible.
For Excel try: Application.DisplayAlerts = False
(For Access: DoCmd.SetWarnings False)
Thanks for the quick fix!