SaveAs - Automatically overwrite existing file
Upcoming Power Excel Seminars
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: SaveAs - Automatically overwrite existing file

  1. #1
    Guest

    Default

     
    I am running a daily report that is saved to a network drive. Since there are links on the Intranet to this file, it has be saved as the same file name everyday, just overwrite the existing one. Question is, how do I get my macro to save the file as that same file name and automatically overwrite the existing file, without popping up and asking me if I want to overwrite?

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Sydney, Australia
    Posts
    2,936
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi,

    Put in

    Application.DisplayAlerts = False
    'Then save your workbook
    Application.DisplayAlerts = True

    This will stop the message popping up.

    Regards,
    D

  3. #3
    Guest

    Default

      
    Awesome, thanks!

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com