Excel Save Properties

[bpeirson]

I have some code which modifies a list of excel files then at the end of a loop I have the commands
ActiveWorkbook.Save
ActiveWorkbook.Close

How do I stop Excel from asking if I want to save changes when the close command is executed. My list is in excess of 300 files, repeatedly clicking "No" is very tedious.

Thanks.

 

[CajunCenturion]

You could try the following:
ActiveWorkbook.Close SaveChanges:=False
or
ActiveWorkbook.Close SaveChanges:=True


Good Luck
--------------
As a circle of light increases so does the circumference of darkness around it. - Albert Einstein

 

[bpeirson]

Works great, Thanks.

 

[cummings54]

The line

Application.DisplayAlerts=False

will turn off warning messages