Surpress Save question

[Guest]

Hello,

I'm pretty bussy finding a way to automate some procedures.
I run whitin access an Excel macro, activated via VB-script.
After running the Excel macro I want to close the Excel worksbook but then
the system is asking me "Do you want to save the changes you made to
'...xls'?"
How ca I surpress this question and still save the changes before closing
the workbook?

 

[Douglas J. Steele]

objActiveWkb.Close SaveChanges:=True