So I am working on the project module when demands the following:-
I have WorkflowA in which I am doing “Read Cell” activity to get few values from an excel sheet (using workbook approach instead of excel application scope) in variables (val1, val2, val3, val4)
here all 4 variables are generic types.
Then I am using “If” activity to compare to do the compare logic (which is working fine as I check with message boxes and log messages)
Then, I am using an “INvoke Workflow File Activity” to switch to another workflow (WorkflowB) depending on the conditions using workflow path. But as I do that and execution from Step One I get error:-
{
“message”: “Invoke Workflow File: Cannot set unknown member ‘UiPath.Excel.Activities.ExcelApplicationScope.MacroSetting’.”,
“level”: “Error”,
“logType”: “Default”,
“timeStamp”: “12:51:49”,
“processVersion”: “1.0.0”,
“jobId”: “MyJobID”,
“robotName”: “My Robot Name”,
“machineId”: 0,
“fileName”: “WorkflowB”
}
And the flow is stuck with the above error.
I checked by keeping a message boxes and log messages in the WorkflowB as soon as it starts. But none of the messages are executed. So I figure out there is an issue with “Invoke workflow file” activity.
And As per the error, there is some excelapplicationscope issue.
But I am not getting why is it showing excel application scope issue in invoke workflow file activity when I am not using any excel activities here.
Also As per my rest of the projects the Invoke workflow file activity works fine. only this one shows this error.
As I already mentioned in my post, I have checked WorkflowB separately, so there is nothing wrong in workflowB and also if condition is perfectly fine.
I just noticed that there was some excel application scope in WorkflowB (but it was commented.)
And as I saw, in usually excel application scope we do not have MacrosSetting, but in the WorkflowB whenever I use Excel application scope, I get that Mracros option also
I tried to set it to disableAll and also EnableAll but for both same error is comming.
First of all, if the stuff is commented, it should not even consider it.
It has been resolved, I had used the excel application scope in the comment section in WorkflowB due to which invoke workflow file activity was giving above issue.