Question

1
Replies
49
Views
 Ashley Winden (AshleyW5)
Optum
Architect
Optum
US
AshleyW5 Member since 2016 5 posts
Optum
Posted: February 7, 2020
Last activity: July 21, 2020
Posted: 7 Feb 2020 11:52 EST
Last activity: 21 Jul 2020 10:24 EDT
Closed

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?

Pega Robotic Desktop Automation Robotic Process Automation Healthcare and Life Sciences Robotics System Architect
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.
Posted: 1 year ago
Posted: 21 Jul 2020 10:24 EDT
Leela Aditya Menda (Aditya Menda)
PEGA
Principal Technical Solutions Engineer
Pegasystems Inc.
IN

Hi,

Yes, you can handle, Clicking "Cancel" button with the help of UIAutomation script. Use script component and write a method to click the cancel button and call the method based on the usage.

Ref Link: https://docs.microsoft.com/en-us/dotnet/framework/ui-automation/ui-automation-overview