Execute macro fails when another excel file is open

[ak_mariam]

Hi,all.
I’m using the execute macro activity but this error occurred when other excel files were opened before running the workflow.
Is there any workaround to make Execute macro successful even if another excel files were opened

Error mssage:
Source:Execute macro
Message:The range does not exist
Exception type:ExcelException

?

regards.

[lainh (HIGASIKUZE TAKAYOSI)]

@ak_mariam

I do not think the error is caused by " another excel files were opened" .
There has an issue maybe help:

Write range activity - Error message "Range does not exist"

Hi I have been having the same error, but it went away when i removed the sheet protection of the file (and unshared it). I hope you can use my picture below despite Microsofts annoying translation: [image] The first (and the one looking most like at retangular square) is “Protect sheet” and the one that looks like its been drawn by a drunk elephant is the “Share project folder”.

Try it.

[ak_mariam]

Thank you for your reply , but my error was not solved.
However, when I turned on the “Visible” option of Excel Application Scope which contains Execute macro, my error has been resolved.

[lainh (HIGASIKUZE TAKAYOSI)]

I’m not sure what you did in the code.but I did that below can execute macro despite of “Visible” option .

Macro:

result:

Try the full path .