Use Application for Excel clicks

Help Studio
,
1

Hi,
I have Use Application\Browser activity for Input.xlsx
I am doing some macro runs in that scope via UI clicks, I need to that way.
After that I am copying the file using copyfile from Input.xlsx to Output.xlsx

  1. Does copyfile work while the file is still open?

  2. If I use Excel Application Scope does not show any macro errors for the same, but if I use Application Scope - it shows macro syntax errors.

Can you advise?

2

@A_Learner

  1. Copy does not work when file is open
  2. When using use application/browser the macro uses user context…so check your macro and correct it

Cheers

3

Thank you @Anil_G

What does it mean by user context?

So in Excel Scope of Input.xlsx after running the macro with hot keys, I was able to copy the file. Why I am not able to copy from Application Scope?

Thank you so much,

4

@A_Learner

Because the file open is being used …in excel application scope the mode might be read only also…or can be opened as background etc

There xan be many reasons depending on what youa re trying to do

Cheers