ActiveWorkbook.Close SaveChanges:=True

--
Regards,
Tom Ogilvy

"Alan" wrote in message
...
Thanks to MVP's from this site I have code that opens and amends and excel
spreadsheet, however when it makes to cloe it gives me the 'Save Changes'
Yes, No, Cancel' Option ... Is there a method to automate yes and disable
this messagebox ??

Many Thanks again