Results 1 to 5 of 5

Thread: [RESOLVED] Disable Excel notifications

  1. #1

    Thread Starter
    Lively Member
    Join Date
    Jan 2009
    Posts
    93

    Resolved [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??

  2. #2
    I'm about to be a PowerPoster! Hack's Avatar
    Join Date
    Aug 2001
    Location
    Searching for mendhak
    Posts
    58,333

    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.

  3. #3

    Thread Starter
    Lively Member
    Join Date
    Jan 2009
    Posts
    93

    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.

  4. #4
    I'm about to be a PowerPoster! Hack's Avatar
    Join Date
    Aug 2001
    Location
    Searching for mendhak
    Posts
    58,333

    Re: Disable Excel notifications

    For Excel try: Application.DisplayAlerts = False

    (For Access: DoCmd.SetWarnings False)

  5. #5

    Thread Starter
    Lively Member
    Join Date
    Jan 2009
    Posts
    93

    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
  •  



Click Here to Expand Forum to Full Width