Closing a workbook during a macro without saving it

Ajtoo · Mar 18th, 2002, 02:49 AM

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 · Mar 18th, 2002, 03:01 AM

Quote:

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 · Mar 18th, 2002, 03:20 AM

Both excellent - many thanks
Andrew

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 18th, 2002, 02:49 AM	#1
Ajtoo New Member Join Date: Mar 2002 Location: London Posts: 5	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?

Mar 18th, 2002, 03:20 AM	#3
Ajtoo New Member Join Date: Mar 2002 Location: London Posts: 5	Both excellent - many thanks Andrew