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

Sendkeys "~", True

might work.

Regards,
Tom Ogilvy

"Robert Chapman" wrote in message
...

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

-----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

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


"Robert Chapman" wrote in message
...

-----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

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?

--

John

johnf202 at hotmail dot com


"Robert Chapman" wrote in message
...

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