Results 1 to 4 of 4
  1. #1
    Lounger
    Join Date
    Jan 2005
    Location
    Colorado Springs, Colorado, USA
    Posts
    44
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Closing without asking to save (VB/Excel 2000)

    This is probably another easy one....

    Is it possible to save and close an existing (Tab .txt) Excel worksheet WITHOUT it prompting you concerning "overwriting" or that "format may be lost"

  2. #2
    Plutonium Lounger
    Join Date
    Nov 2001
    Posts
    10,550
    Thanks
    0
    Thanked 7 Times in 7 Posts

    Re: Closing without asking to save (VB/Excel 2000)

    Surely that syntax would discard the changes. I think the requirement was to save in a format that may lose information without getting any warnings.

    I think the solution is to put
    Application.DisplayAlerts = False
    before the save, and set it back to True afterwards.

    StuartR

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Closing without asking to save (VB/Excel 2000)

    Sorry, I was too quick on the draw. I will edit my reply. Thanks for pointing out my error.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Closing without asking to save (VB/Excel 2000)

    Incorrect reply deleted by HansV. Please see StuartR's reply.

Posting Permissions

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