Hi
@Helene Knox,
I think the issue might with how you are renaming the file there in step #6 as if you do that Workbook Name may no longer be recognized. Ideally, my suggestion would be to follow either of the below two approaches:
1) First, you close the file and instance once you are done saving the file as the new renamed file. Once, instance is closed successfully provide some minor delay using wait stage and then again open a new instance and newly renamed excel file. Then, you use the
Delete Row(s) action with all the new parameters used during this handle.
2) Otherwise, the second approach would be that you first delete the rows in excel using
Delete Row(s) as soon as you determine what all rows you need to delete from collection. Once the rows are deleted, then you save the file as the renamed file. This is a much cleaner approach since we do everything within the original handle that was created. Since from your steps, it looks like there are no changes that need to happen in the original file hence, the changes only need to be reflected in your renamed file.
Also, you don't need
Activate Worksheet action before using
Delete Row(s) action. It should work directly.
----------------------------------------------------------------Hope it helps you out and if my solution resolves your query, then please mark it as the 'Best Answer' so that the others members in the community having similar problem statement can track the answer easily in futureRegards,Devneet MohantyIntelligent Process Automation Consultant | Sr. Consultant - Automation Developer,WonderBotz India Pvt. Ltd.Blue Prism Community MVP | Blue Prism 7x Certified ProfessionalWebsite: https://devneet.github.io/Email: devneetmohanty07@gmail.com----------------------------------------------------------------
----------------------------------
Hope it helps you out and if my solution resolves your query, then please provide a big thumbs up so that the others members in the community having similar problem statement can track the answer easily in future.
Regards,
Devneet Mohanty
Intelligent Process Automation Consultant | Technical Business Analyst,
WonderBotz India Pvt. Ltd.
Blue Prism Community MVP | Blue Prism 7x Certified Professional
Website: https://devneet.github.io/
Email: devneetmohanty07@gmail.com
----------------------------------