I have an error while running my workflow.
I am calling a macro two times from the same file but a different macro name.
I think the issue is because the automation might think that the workflow of the first macro called is not yet done.
But actually it is already finished and close the workbook.
I also have tried to put a delay between the two macro calling.
But the error still happen.
I have my workflow in different module and calling each macro with different excel application scope.
Can anyone help me with this ?