close excell without getting the message asking to save

[Fursten]

Hi,

I´m changing an excell file programatically... If I close the object programatically I will get a message box asking if I want to save changes.

I would like to program the file so if I make a change and not want to save it, I will cancel what I have done and this way I will not get that massage asking to save the file...

Thank you

Sérgio Oliveira

 

[JustinEzequiel]

check out the .Saved property of the WorkBook object
set this to true before closing then Excel won't ask you if you want to save changes

 

[Mattprd]

Not too sure if this is exactly what you want but if you use this code,

Application.DisplayAlerts = False

this will ignore the message box BUT it will save the file.

 

[uberpudge]

Passing "XlSaveAction.xlDoNotSaveChanges" as the parameter for the "Close" method works for me.
Example:

Public Sub CloseMyWorkbook()
ActiveWorkbook.Close SaveChanges:=XlSaveAction.xlDoNotSaveChanges
End Sub


Hope this helps,
Pete

 

[markSaunders]

another, nice and easy approach is

xlBook.Close savechanges:=False

Mark Saunders