close other workbook - close excel - do not save
Posted on 2014-03-08
We have a data work book that is used to copy data from Access.
The data is linked to a second workbook
We use VBA code to save the second workbook and break the links to the data work book
We want to close the data workbook without saving, after the code has run
How do I close the Data workbook from within the code on the second workbook?
I do not want any alerts.
It would also be ok to quit excel with no alerts as the second workbook was saved earlier