Results 1 to 3 of 3

Thread: How to stop save box appearing at the time of Excel exit

  1. #1
    Join Date
    Nov 2011
    Posts
    166

    How to stop save box appearing at the time of Excel exit

    How to disable "Do you want to save the changes to <file name>" manual prompt every time while closing excel files having macros (macro password not known), while in automated task mode which is closing and opening files automatically. Thanks

  2. #2
    Join Date
    Jul 2011
    Posts
    440

    Re: How to stop save box appearing at the time of Excel exit

    If I want to close another workbook in VBA, I would use something like: workbooks("otherworkbook.xls").close savechanges:=false (false means I want to discard those changes.)

  3. #3
    Join Date
    Jul 2011
    Posts
    434

    Re: How to stop save box appearing at the time of Excel exit

    My problem is I have approx. 6000 excel files and these files go as input to a software program which automatically picks data from these files by opening and closing them on its own. But since these files contain macros so every time a self opened file is closing down and then it asks for a manual intervention to save changes or not, which defies the whole purpose of automation. I am a very basic user of excel and so would like to know how can I stop that prompt so that the whole process runs smoothly.

Similar Threads

  1. How to stop irritating Save As dialog box in Microsoft Excel
    By Abélard in forum MS Office Support
    Replies: 2
    Last Post: 21-02-2012, 12:54 PM
  2. Excel Takes Long time to save a file
    By (Cowherd) in forum Windows Software
    Replies: 2
    Last Post: 21-01-2012, 01:44 PM
  3. The Sims Medieval: Unable to save or exit
    By Ro-Man in forum Video Games
    Replies: 5
    Last Post: 14-06-2011, 10:53 AM
  4. How can I stop tablet input panel from appearing on start up?
    By envo diverter in forum Windows Software
    Replies: 3
    Last Post: 14-08-2009, 06:47 PM
  5. How to Save settings on Exit Windows
    By Boy_Genius in forum Tips & Tweaks
    Replies: 1
    Last Post: 25-12-2008, 12:00 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,711,659,083.35768 seconds with 17 queries