Results 1 to 2 of 2
  1. #1
    Join Date
    May 2005
    Posts
    119

    Unanswered: overwrite prompt.. how do I stop it?

    Does anyone know how to stop the verification message "a file named morning report data.xls already exists in this location. Do you want to replace it?"?

    My code is as follows:
    ActiveWorkbook.SaveAs "morning report data.xls", and the answer should always be YES!

    By the way, where is everyone? No one has added anything to this site since my last update on 10/28/05!

    Thanks,
    Krista

  2. #2
    Join Date
    May 2005
    Posts
    119
    Nevermind, I just figured it out.

    Application.DisplayAlerts = False

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •