Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Ashley Winden (AshleyW5)
Optum
Architect
Optum
US
AshleyW5 Member since 2016 5 posts
Optum
Posted: Feb 7, 2020
Last activity: Jul 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?

To see attachments, please log in.
Pega Robotic Desktop Automation
Robotic Process Automation
Healthcare and Life Sciences
Robotics System Architect

Posted: 4 years ago
Posted: 21 Jul 2020 10:24 EDT
Leela Aditya Menda (Aditya Menda)
PEGA
Senior Principal Technical Support Engineer, Robotic Process Automation
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

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice