Attachmate Extra! Verses Reflection Desktop _ Excel VBA

[mchilapur]

Hello All Excel Experts,
I have developed an Macro in Excel to automate a task in Attachmate Extra.! Since now we are migrating from Attachmate Extra to Refection Desktop (Micro Focus), I tried running the same Excel Based Macro into it to perform the task.
To my bad luck, Excel Macro started sending/pasting values at wrong fields in Reflection Desktop. But when i tested the same code slowly using F8 key, it works perfectly fine.!!
What may the cause of this issue..?

Below is the sample code i used. Like below, i send several data at different co-ordinate places, wait for the cursor to stand at that position and then send the data.
How can i modify Excel based Macro to cope with Reflection and make sure it sends correct data at right places..?

*************************************************

targetrow = 2
targetcol = 7
Sess0.Screen.moveto targetrow, targetcol
Sess0.Screen.WaitForCursor targetrow, targetcol
Sess0.Screen.SendKeys "7"
 
targetrow = 4
targetcol = 24
Sess0.Screen.moveto targetrow, targetcol
Sess0.Screen.WaitForCursor targetrow, targetcol
Sess0.Screen.SendKeys "We Need it"
 
targetrow = 4
targetcol = 58
Sess0.Screen.moveto targetrow, targetcol
Sess0.Screen.WaitForCursor targetrow, targetcol
Sess0.Screen.SendKeys "Done"
 
Sess0.Screen.SendKeys ("ENTER<enter>")<enter>

*************************************************


Any suggestions will be of great help.
Thanks in advance.</enter></enter>

 

[jase28r]

Hello All Excel Experts,
I have developed an Macro in Excel to automate a task in Attachmate Extra.! Since now we are migrating from Attachmate Extra to Refection Desktop (Micro Focus), I tried running the same Excel Based Macro into it to perform the task.
To my bad luck, Excel Macro started sending/pasting values at wrong fields in Reflection Desktop. But when i tested the same code slowly using F8 key, it works perfectly fine.!!
What may the cause of this issue..?

Below is the sample code i used. Like below, i send several data at different co-ordinate places, wait for the cursor to stand at that position and then send the data.
How can i modify Excel based Macro to cope with Reflection and make sure it sends correct data at right places..?

*************************************************

targetrow = 2
targetcol = 7
Sess0.Screen.moveto targetrow, targetcol
Sess0.Screen.WaitForCursor targetrow, targetcol
Sess0.Screen.SendKeys "7"
 
targetrow = 4
targetcol = 24
Sess0.Screen.moveto targetrow, targetcol
Sess0.Screen.WaitForCursor targetrow, targetcol
Sess0.Screen.SendKeys "We Need it"
 
targetrow = 4
targetcol = 58
Sess0.Screen.moveto targetrow, targetcol
Sess0.Screen.WaitForCursor targetrow, targetcol
Sess0.Screen.SendKeys "Done"
 
Sess0.Screen.SendKeys ("ENTER<enter>")<enter>

*************************************************


Any suggestions will be of great help.
Thanks in advance.</enter></enter>

Hi Im looking for some help as i to have migrate to reflections and can not get my VBA to run, can you please share the full code so i can get some idea of how you set it to find the sassion please.