SetCursorPos

[DejaVu]

I'm trying to get some code that will control the cursor position on my AS400. I need to set the cursor to position 15, 9, then send the command F2.
Here is my code:
PS1.SetCursorPos 15, 9
OIA1.WaitForAppAvailable
OIA1.WaitForInputReady
PS1.SendKeys "[pf2]", 15, 9
OIA1.WaitForAppAvailable
OIA1.WaitForInputReady

This does not work, however, because it will not set the cursor position unless I somehow activate the AS400 window, then set the cursor position, then send F2. I'm not sure how to do this with code, or if there is any other way around it.

Anyone know how to solve my little problem?

TIA,

DejaVu

[bigwheel]

So, what version of Excel are you using?

[DejaVu]

Microsoft Excel 2003

Maybe this will help. I used:
Dim PS1 As AutPS, OIA1 As AutOIA