Hi in my project I am opening same excel file in three times in different 3 stages and it is containing macros. So I need if Once I opened excel It should not close until my entire project complete.
My existing project is working as all the three times opening excel file executing the macro and closing.
Simple Use excel scope application inside that you automate
if you need to open the application you have use open application activity.
excel application scope is read the excel file and if excel file is open it wont through error
i Hope you get the solution and please mark it as solution and close the thread
Regards
Chethan P
2 Likes
Use Start process activity and pass the excel file name it will open the excel file similar to how we manually open the file…
Thanks
1 Like
Hi Thanks I have passed variable at output used it is keeping always open my excel
1 Like
it ok if have any dought ask me
Happy automation
1 Like
sure
hello, tell me, if the excel file is open, will it cause an error or not?
Hi no error it is working fine