SendKeys {Enter} acts like Return rather than Enter

[Robert Chapman]

I'm trying to automate QMF from Excel (to automate the
process of exporting a QMF query as an Excel file). This
involves selecting the QMF application and using Sendkeys
to send all the relevant keystrokes. The only problem is
when I try:

Sendkeys "TRAN", True
Sendkeys "{Enter}", True

TRAN appears onscreen but then Enter isn't pressed. It
appears that Return is pressed since the cursor moves to
the beginning of the line as when you press Return in
QMF. Given that Enter and Return have the same effect in
Excel is there another way I need to refer to Enter to get
this command to work in another application?

Many thanks for any help.

Rob

 

[Tom Ogilvy]

Sendkeys "~", True

might work.

Regards,
Tom Ogilvy

 

[Robert Chapman]

-----Original Message-----
Sendkeys "~", True

might work.

Regards,
Tom Ogilvy

Thanks for the idea Tom but it doesn't seem to change
anything. Could it be something to do with some kind of
application settings in Excel or QMF that makes Enter act
differently? Or is SendKeys pretty uniform over
applications?

Thx,

Rob

 

[Tom Ogilvy]

I guess I am missing the distinction between Return and Enter. On my
keyboard, I have no return key. On older keyboards, I believe the enter key
may have been called Return. I have always thought of them as synonymous.

QMF is a mainframe product isn't it - IBM 3270 type stuff. Perhaps it has
to do with your keyboard emulation.

Regards,
Tom Ogilvy

 

[jaf]

Hi Robert,
What happens if you type TRAN and press enter in QMF?

If this is like a VBA userform textbox.
Then does the ENTER event in the textbox do something, or do you need to set
the focus on a button to create an event that starts the processing?

 

[Tom Ogilvy]

In application.sendkeys rather than sendkeys you can specify the
difference:

ENTER (numeric keypad) {ENTER}
ENTER ~ (tilde)



Go to the VBE, in a module, type
application.sendkeys

highlight the complete phrase and hit F1.

I guess you would want
Application.Sendkeys "{ENTER}",True

Regards,
Tom Ogilvy

 

[Tom Ogilvy]

just to qualify - at least looking at the help for each would lead one to
believe what is sent is different in application.Sendkeys. I don't have a
way to test the difference - but you can try it and see if it makes a
difference.