Solved

Excel SaveFile YesNoCanel box

Posted on 2011-09-16
5
251 Views
Last Modified: 2012-06-22
In VBA how do I force answer Yes each time I want to save a file.  I have a file that I save to multiple locations and I want it to not need that question answered each time.  Can this be done?  -R-
FileSaveYesNoCancel.png
0
Comment
Question by:RWayneH
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
5 Comments
 
LVL 6

Assisted Solution

by:effes
effes earned 150 total points
ID: 36551768
Have a look at his: http://www.vbforums.com/showthread.php?t=528826

Hope that helps.
0
 
LVL 27

Accepted Solution

by:
Glenn Ray earned 350 total points
ID: 36551879
In VBA, add the following line of code early in the macro:

Application.DisplayAlerts = False

This will disable overwrite messages such as above.

You also need turn this back on before exit.
Application.DisplayAlerts = True
0
 

Author Comment

by:RWayneH
ID: 36551922
Thanks!!  Will this work when deleting sheet tabs too?  -R-
0
 
LVL 27

Expert Comment

by:Glenn Ray
ID: 36551969
RE: Deleting sheet tabs...yes, it will.

That's why you have to be careful with this function.  If it remains FALSE, you can bypass messages during your Excel session that might prevent accidental overwriting/deletion.
0
 

Author Closing Comment

by:RWayneH
ID: 36552829
Thanks for the help. -R-
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…

729 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question