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" <prometheus...@excite.com.au> 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" <prometheus...@excite.com.au> 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?

On Apr 6, 9:14 am, "Prometheus" <prometheus...@excite.com.au> wrote:
> 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?

The only way that I can think that this would be possible is through
DDE or through adding the library files. The issue with both of these
though is figuring out how the objects, properties, and methods act
when used in the VBA code.

If you want to add a library, within VBE you can go to Tools/
References and find the library that corresponds to that program. In
essence, you'd have to do a lot of "playing around" to figure it out;
especially if the program is not widely used and you can't simply post
to google groups or some other website to get help.

Matt