G'day all,

Is there a way to use and excel macro to activate an open window (non-
excel based) and send keystrokes to it?

For Example I need the macro to activate "TTWin Session 1" window open
on my screen and send various keystrokes in order to navigate through
the terminal.

Is it possible and if so how?

Cheers all....

On Apr 6, 6:51 am, "Prometheus" wrote:
G'day all,

Is there a way to use and excel macro to activate an open window (non-
excel based) and send keystrokes to it?

For Example I need the macro to activate "TTWin Session 1" window open
on my screen and send various keystrokes in order to navigate through
the terminal.

Is it possible and if so how?

Cheers all....

This is possible; however, SendKeys should be a last resort. If the
system has DDE (Dynamic Data Exchange) then DDE would be a better
alternative (search VBE Help for dde). Otherwise, in short the
following should work (it uses SendKeys).

AppActivate "TTWin Session 1"
Application.SendKeys "c", True
'search VBE Help for SendKeys to see how to use all keyboard
combinations.

Matt

matt wrote:
On Apr 6, 6:51 am, "Prometheus" wrote:
G'day all,

Is there a way to use and excel macro to activate an open window (non-
excel based) and send keystrokes to it?

For Example I need the macro to activate "TTWin Session 1" window open
on my screen and send various keystrokes in order to navigate through
the terminal.

Is it possible and if so how?

Cheers all....

This is possible; however, SendKeys should be a last resort. If the
system has DDE (Dynamic Data Exchange) then DDE would be a better
alternative (search VBE Help for dde). Otherwise, in short the
following should work (it uses SendKeys).

AppActivate "TTWin Session 1"
Application.SendKeys "c", True
'search VBE Help for SendKeys to see how to use all keyboard
combinations.

Matt

Thanks... nice and easy this one!

Follow up question if I may....

Can Excel through VBA "read" information from the TTWin window.

The window is a Terminal window with Text only. Is is possible to get
Excel to read for example characters 2-4 of Line 5 of the Terminal and
place on a sheet?