Excel ,Invoke VBA ,Invoke Code issues

Hello , trust you are great. I am having some issues understanding what to do now. Until now , I have been using subs with invoke VBA which I have to use in an excel application scope and this has been pretty understandable for me because I was just working with a single excel and moving/filtering data across the sheets. Right now I am supposed to work on two excels at the same time . so I am supposed to filter data on sheet A of excel 1 and move the result to sheet A of Excel 2. I really want to achieve this using invoke VBA or invoke code. I do not want to use datatable as this is what I am avoiding . but the invoke VBA is called only in a single excel application scope which would be excel1 , what then would I use for excel 2. The invoke code is throwing a lot of errors which I do not understand right now and would require a sample working workflow to understand…help

Please help me as I am already behind my timeline .
Please…
Best Regards

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."

:bulb: 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 hope this helps! :slight_smile:

2 Likes