Excel: Pass a Cell to doubleclick to AutomationAnywhere

[cavallino]

Hello,

I have a "simple" task to do in Excel, however, with AutomationAnywhere it is not so simple anymore. I can do anything re. Excel on my own but I do not know how to involve Automation Anywhere.

What I would like to do is:

I doubleclick on any cell in Sheet2. Automation Anywhere should doubleclick the same cell in Sheet1.

So, in Sheet2 I have an event Worksheet_BeforeDoubleclick that will pass the cell address doubleclicked and my destination "Sheet1" to an AutomationAnywhere macro. How do I create that macro and how do I fire it?

In Automation Anywhere help I read about "Excel - How to use" and that there are commands like open spreadsheet, getcells, goto cell etc. but I do not know how to pass the variables (sheet and cell).

Any help on any step to solve my problem would be greatly appreciated.

regards

arno

PS: I know that there are Application.Doubleclick and Worksheet_BeforeDoubleClick events available in Excel VBA, however, they cannot solve my problem. I need a "real" doubleclick faked by some software

PPS: I found how to fire the macro in the helpfiles. However, I still do not know how to setup the macro that is doing the doubleclick for me.