Posted: 7 Feb 2020 11:52 EST Last activity: 21 Jul 2020 10:24 EDT
Microsoft Excel Component - Close Excel Without Saving
I have an automation that launches an Excel document and does some automatic filtering. When it is done I would like to close the Excel without saving. Currently, when I use the Close method for the microsoftExcel component, a file explorer dialog box pops up asking me where to save the document. Do I have to handle clicking 'Cancel' on this dialog box? Or is there a way to close without saving or undo all changes automatically?