[RESOLVED] excel worksheet ACCEPTALLCHANGES method problem

Hi there! when im using the SaveAs method in workbooks and tries to close it, theres always a popup that asks me if i would like to save my changes. i saw a property that says .AcceptAllChanges.. but i dont know what will i put in [WHEN], [WHO], [WHERE].. can anyone help? thanks!

how can i use this method? can anyone give me a sample? Thanks!

VB Code:

oWB.SaveAs FileName:="C:\Test.txt", FileFormat:=xlTextMSDOS
oWB.Saved = True
oWB.Close
Set oWB = Nothing
'...

:)