Can anyone help for vbs file how to work in activity

You need to supply either the TargetType or the TargetObject but not both.

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