Closing a workbook during a macro without saving it

[Ajtoo]

I wish to close a workbook during a macro without saving it.
Currently, the vba command 'ActiveWorkbook.Close' brings up the usual dialogue box asking if I wish to save or not and I am able to select No, but wish to automate this process.
Due to the large amount of data, I also get a message if I want to save the data in the clipboard - again I wish to automate the No option.
How can I do this?

 

[Ivan F Moala]

On 2002-03-18 01:49, Ajtoo wrote:
I wish to close a workbook during a macro without saving it.
Currently, the vba command 'ActiveWorkbook.Close' brings up the usual dialogue box asking if I wish to save or not and I am able to select No, but wish to automate this process.
Due to the large amount of data, I also get a message if I want to save the data in the clipboard - again I wish to automate the No option.
How can I do this?

ActiveWorkbook.Close False


For the clipboard...just clear it with
Application.cutcopymode = false


HTH

Ivan

 

[Ajtoo]

Both excellent - many thanks
Andrew