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?

It looks like you're mixing excel and word.

If you want to close a workbook, you could use:

activeworkbook.close savechanges:=false

And
application.cutcopymode = false

should stop the clipboard message.

Tony wrote:

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?

--

Dave Peterson

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?