I’m currently using Invoke VBA code, in order to run a macro over some excel files. This code is supposed to return a value, which I would like to use in the UiPath workflow.
In order to achieve this, I’ve created an object variable and set it in the result field of the Invoke VBA code activity.
The problem is that I’m not sure how to link the VBA internal variable to the external one.
Can someone please assist?