Tim

I am so sorry for not responding sooner - your message has only just shown up.

I'll try it out tomorrow morning

Many thanks.

Kind regards

Ian

"Tim Williams" wrote:

Try this:

Sub Tester()
Application.DisplayAlerts = False
ActiveWorkbook.Close False
Application.DisplayAlerts = True
End Sub

Tim


"PaddyMac" wrote in message
...
I wish to automate the closing of an Excel workbook so that Excel does
not save any changes, but does save what has been copied to the
clipboard.

I have got as far as.

ActiveWorkbook.Close

and am stuck

Any ideas?

Many thanks.

Kind regards

PaddyMac


.