This is macro code right @Bhagyashri?
save the file with .vb extension and
Then use excel application scope and then use Invoke VBA activity to run the macro
Good morning,
You can use the Invoke Vbscript activity to accomplish this task.
Hi @Bhagyashri
Please try using these two activities:

The Invoke VBA requires it to be placed in the Excel Application Scope.
@Bhagyashri Just for your Reference .
Thanks for u Help…its working but my code is much lengthy
Unable to find ri8 solution
Which path is to give in excel application scope
