Close Excel workbook without saving

Hi,

I was wondering if there’s anyway, after I opened the Excel and made some edits in it, to close the workbook without saving it?

Sure, just don’t use Write Range or Write Cell cause they save the file. :slight_smile:

What if I ran an macro that processed some data in the file and I want the file to go back when I found it, how can I accomplish that?

You should be good as long as the Macro doesn’t have a SaveAs programmed in. You might need to open the file first with Excel Scope. Once your macro has executed, just retrieve the info you need and close Workbook.

If you still have trouble, you could always create a backup of the file so you can return it back to its original form.

You may need to uncheck the AutoSave Options.

3 Likes