Execute macro fails when another excel file is open


#1

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.


#2

@MarikoUsui

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

Try it.


#3

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.


#4

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

Macro:
image

result:
image

Try the full path .