Hi @David_Oku
I understand that your problem is
" the invoke VBA is called only in a single excel application scope which would be excel1 , what then would I use for excel 2."
How about copying the excel 1 sheet to excel 2 first using the Copy Sheet activity
and then perform your VBA? Then, after completing your process, you can delete the copied sheet.
P.S.
-
I can’t resist encouraging you to reconsider using Datatable activities. You might want to check out the comments to this one as it is similar to your objective.
Copy and paste filtered results only -
Or if you are only handling Excel application, maybe you can utilize StudioX.
StudioX - Tutorial: Filtering Data in Excel
I hope this helps!