Excel Save Properties
Excel Save Properties
(OP)
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.
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.





RE: Excel Save Properties
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
RE: Excel Save Properties
RE: Excel Save Properties
The line
Application.DisplayAlerts=False
will turn off warning messages