Also, no need to use the invoke method activity. That activity is used only for VB.NET methods. You are trying to run a function or subroutine in your VBA file, so the ‘Invoke VBA’ activity is all that you’ll need.
1 Like