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?
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?