I am trying to close a spreadsheet without saving any changes to it from
within a macro, but at the moment it keeps asking me do I want to save
changes.

The code so far is

Windows("control of contract - item 1.xls").Activate
ActiveWorkbook.Close

Can someone help.

I don't want to save before closing which would get rid of the message
because it takes about 10 seconds to close.

Thanks for any replies
Okanem


--
okanem
------------------------------------------------------------------------
okanem's Profile: http://www.excelforum.com/member.php...fo&userid=9301
View this thread: http://www.excelforum.com/showthread...hreadid=320054