+ Reply to Thread
Results 1 to 6 of 6

Disable save prompt for all files in current folder?

  1. #1
    Registered User
    Join Date
    11-14-2012
    Location
    Derby, England
    MS-Off Ver
    Excel 2013
    Posts
    32

    Disable save prompt for all files in current folder?

    Hello,

    Lets say I have a folder (which we'll call Forms), which contains a number of Excel files. The names of these files will change each day. All files in the folder need to be printed at the end of each day. Problem is - these files contain volatile formulas or linked pictures (not sure which), this is causing the save prompt to occur for each file as it prints.

    I would like my code to run from a workbook that will hold only this code (attached to buttons), the workbook could then be pasted into the 'Forms' folder each day, opened, code is then run which will disbale the save prompt for all the files in the 'Forms' folder (or disable the save prompt for the Excel application would be fine too). Then I guess a second piece of code could turn the save promt back on.

    I've tried using the Application.DisplayAlerts function, but it doesn't seem to do the trick.

    Any help would be greatly appreciated,
    Gregg
    If somebody helps you, say thanks, by clicking *

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,609

    Re: Disable save prompt for all files in current folder?

    Try
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    11-14-2012
    Location
    Derby, England
    MS-Off Ver
    Excel 2013
    Posts
    32

    Re: Disable save prompt for all files in current folder?

    Hi Kaper,

    Thanks for the quick reply - however, if I understand your code correctly (which I may not, as I'm a complete VBA novice) - wouldn't this code require me to explicitly name each file to be printed within the procedure?

    Names of the individual Excel files will change each day, as will the name of the folder holding them. So I guess only code that disables the save prompt for the entire Excel application will do the trick?

    Thanks,
    Gregg

  4. #4
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,609

    Re: Disable save prompt for all files in current folder?

    Hi Greg,
    As long, as you only describe (not show) your code, I can only guess how it looks like.
    Probably at some point you have there a workbook tp be printed open (and active?) And probably you close it. If so it is enough to change
    Please Login or Register  to view this content.
    to
    Please Login or Register  to view this content.
    Anyway - as long as we only guess what is in your code, we (I?) can only guess what will be the correct answer.

  5. #5
    Registered User
    Join Date
    11-14-2012
    Location
    Derby, England
    MS-Off Ver
    Excel 2013
    Posts
    32

    Re: Disable save prompt for all files in current folder?

    That's true Kaper - however, there isn't any code to post. Like I said, I thought 'Application.DisplayAlerts = False' might disable alerts for all Excel until I ran 'Application.DisplayAlerts = True', but that didn't seem to work.

    At the end of each day, all files in the folder will be highlighted, then right mouse click and 'Print' is selected. So all files can be printed at once. The problem is, that as Windows opens each file to print, the save prompt is kicking in.

    So you're suggestion in previous post may work - but I would have to combine it with some other code to form a loop of 'when each workbook opens, Activeworkbook.Close, Activeworkbook.Close savechanges:=false'

    But I have no idea how to write that! If you could help at all, it would be much appreciated.

    Gregg

  6. #6
    Registered User
    Join Date
    11-14-2012
    Location
    Derby, England
    MS-Off Ver
    Excel 2013
    Posts
    32

    Re: Disable save prompt for all files in current folder?

    If anybody else has an idea of how this code may look, it would be much appreciated!

    Thanks,
    Gregg

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Save to non-outlook folder prompt
    By dreinisch in forum Outlook Formatting & Functions
    Replies: 0
    Last Post: 12-12-2013, 03:50 PM
  2. Replies: 1
    Last Post: 11-12-2013, 03:44 PM
  3. Disable Save Prompt
    By Daeghen in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-14-2012, 08:30 AM
  4. excel disable save but enable with password prompt?
    By techmob in forum Excel General
    Replies: 6
    Last Post: 06-17-2011, 03:11 PM
  5. Disable save changes prompt
    By teddybouch in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-21-2008, 04:23 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1