Tony

if, by closing the Active Window, you want to close the Active Workbook, try
something like:

Workbooks("BOOK1.XLS").Close SaveChanges:=False

Check the VBA Help.

Regards

Trevor


"Tony" wrote in message
...
Hi,
Im working with Excel 2003. This line is supposed to allow
me to close an active window without being asked to save
any changes:

ActiveWindow.Close SaveChanges:=wdDoNotSaveChange

It does not work. Any ideas on what does work?

Also, how can I prvent the message about saving the
clipboard from being displayed?