(Functional) Sendkeys from Excel

[gazza110]

Hi,

I have written an excel macro to appactivate an open Extra! session and then select all copy and paste into excel.

This works OK, however after the first lot of data has been copied and pasted, I need to be able to page down on extra to the next set of data to copy, however using {PGDN} sendkeys option does not work.

The keyboard map shows <RollUp> which is a sendkeys string in extra. However when I have tried to SendKeys ("<RollUp">) from excel it just sends each individual keystroke ' < R O L E ' (etc).

Is there anyway I can get this to work.

Also the Left Ctrl key on the keyboard has been assigned to 'Reset' - then you Sendkeys ^ this does reset the system, this is OK for some things, however I want to Select all (Ctrl+A) WITHOUT resetting the system - any way of getting extra to select all data bypassing the reset which occurs as soon as the Ctrl command is sent ??


Many Thanks,
Gaz.

 

[calculus]

The control and shift commands in SendKeys don't work the way they are documented to work. I don't know that you can send Ctrl-A in this manner.

For SelectAll, use this:

Sess0.Screen.SelectAll
Sess0.Screen.Copy

Also, you need to send the actual keys you press to get the desired results. On my system, PageDown is usually a Pf7 or Pf3. So I use this code:

Sess0.Screen.SendKeys ("<Pf7>")

You may also want to look at the FAQ:
I'm ready for Extra Basic... now what? faq99-4087

Hope this helps a bit,

calculus