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
You can use the Invoke Vbscript activity to accomplish this task.
Please try using these two activities:
The Invoke VBA requires it to be placed in the Excel Application Scope.
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