How to avert the save MessageBox prompt in Excel-VBA?

Question

I have a problem here if you look at my codes below after I call the .close line which was the file I initially copied from. It will prompt a save MessageBox message either yes, no, or cancel. Is there anyway I can avoid this save message from appearing programmatic if no was the case could I just programmatic program it no instead?

datatoo · Accepted Answer · 2011-07-26 03:42:47Z

10

Jon is right to suggest Application.DisplayAlerts and if you want to answer no to a save as you suggest

 Workbooks(Filename1).Close SaveChanges:=False

answered Jul 26, 2011 at 3:42

datatoo

2,0792 gold badges21 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Jon Raynor · Accepted Answer · 2011-07-26 03:18:25Z

5

Try setting the Application.DisplayAlerts to false, then closing. I recommend turning it back on after setting it.

Application.DisplayAlerts = False
ActiveWorkbook.Close
Application.DisplayAlerts = True

answered Jul 26, 2011 at 3:18

Jon Raynor

3,9126 gold badges33 silver badges45 bronze badges

Comments

RBarryYoung · Accepted Answer · 2011-07-26 03:22:12Z

0

IIRC:

Workbooks(FileName1).Save

If you save it explicitly, it won't have to ask you.

answered Jul 26, 2011 at 3:22

RBarryYoung

57k15 gold badges99 silver badges142 bronze badges

Collectives™ on Stack Overflow

How to avert the save MessageBox prompt in Excel-VBA?

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related