Excel application scope for read only excel

studio

#1

Hi, I have an excel which is password protected. Supplying the password on Excel Application Scope helps opens the password but upon opening I will receive this pop up.
Even if I place a “Click” activity in Excel Application scope to click yes, it stopped before getting to the step.

Capture


#2

Can you put a delay before “click yes” and also use “image exists” to check whether the popup has appeared or not…


#3

It is not a matter of the pop up appearing too late.
I’ve placed a log message between Excel Application Scope and Click activity, robot did not even write the log message. It was already stuck at Excel Application Scope.


#4

Use parallel activity.

  • In 1st Parallel sequence, give Excel application scope.

  • In 2nd Parallel, give click on pop up


#5

@inyourgravity Try to read excel using WorkBook Read Range activity. Check this option once.


#6

Doesn’t work, it didn’t write either of the lines and is stuck where the pop up appears


#7

The file is password protected, workbook read range couldn’t supply the password


#8

Managed to get it to work by using a Start Process in 1st Parallel instead, also have to indicate ContinueOnError as true, otherwise it will throw an exception after completing the 2nd parallel sequence.


#9

@inyourgravity Workbook read range has password option check it once.


#10

Omg, I don’t know why I didn’t see it just now. I tried it , works as well.


#11

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