-
Jun 30th, 2010, 07:59 AM
#1
Thread Starter
Lively Member
[RESOLVED] Disable Excel notifications
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??
-
Jun 30th, 2010, 08:11 AM
#2
Re: Disable Excel notifications
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.
-
Jun 30th, 2010, 08:40 AM
#3
Thread Starter
Lively Member
Re: Disable Excel notifications
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.
-
Jun 30th, 2010, 08:47 AM
#4
Re: Disable Excel notifications
For Excel try: Application.DisplayAlerts = False
(For Access: DoCmd.SetWarnings False)
-
Jun 30th, 2010, 08:56 AM
#5
Thread Starter
Lively Member
Re: Disable Excel notifications
Thanks for the quick fix!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|