In one of our processes, there is a need for more Excel modeling than what the MS Excel VBO offers. We needed to model the variations of the "Paste" command.
We have an object that uses various MS Excel VBO stages and then calls upon an object that we modeled in Excel. The problem we are having is that the object looses focus on the Excel workbook when exchanging stages from the BP object to our object.
We have tried passing the "handle" instance but that did not appear to make a difference. We have also considered using the "Child Index" value but are unclear on how to use that.
Please let me know if you need further explanation.
Thank you.