Click activity error - Could not open the specified workbook

Help Activities
, ,
1

Hello there,
in a course im following on academy, we are automating excel and in the automation there is a part where i need to click in a sequence. in the click field, where the excel is indicated, im getting an error when i click on the excel link. the error says
could not open the specified workbook. make sure there is no other workbook with the same name already openened. if the workbook is password protected, please eter the correct password

this while the excel is open and not pasword protected

appreciate the help
micky

2

Hey Michael,

In your workflow , add a sequence to check if the excel application is open.

If open close the application and then start.

It is always recommended to check for any open applications and close if any just like how we do in init state of ReFramework.

Hope this helps you out.

Please mark as solution if it does.

Happy automating.!!

3

Hi @Michael_Brumloop

Before automating the excel operations try using Kill Process activity to kill the excel so that it is not open in Background.

image
image437Ă—186 5.55 KB

Check the below thread too.

Regards

4

Thanks, but this doesnt work, seeing that the workbook needs to be open to use the activity, or to set the activity.

5

i didnt use the “kill process”, but the link to the other post you gave did help me to finish the flow even though it was a bit different than what the course sets. i had to use the classic version instead of the other version

6

Hi @Michael_Brumloop

Hope your query is resolved. If yes, please mark my post as solution to close the loop or if you have any queries I’m happy to help.

Regards

1 Like
7

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.