Passing keystrokes

[Guest]

I've got a question about objects embedded into a worksheet.

I've been able to successfully embed and operate a RUMBA display screen via an Excel spreadsheet. What I would like to do is emulate keystrokes to the screen with the VB code. For example: have a "Log on" button that would pass the neccessary keystrokes and to the embedded display screen and fill in ID and password based on data supplied to the excel by the user.

I have found very little in regards to embedded objects. I know that Excel is not directly running the program (ie. passing telnet commands) but it seems to me that one would be able to pass simple key strokes(TAB,ESC, and alphanumerics) to the object. Would this be accomplished with the "verb" command similar to the connect command sent to the server?

Any input at all would be greatly appreciated.

Thanks,

Ryan

 

[Toby Erkson]

I'm learning VBA for Excel2002 so I can't help too much but during my
reading of one of John Walkenbach's books I came across this the "SendKeys"
command. Try searching the Help for it. Hope this helps...

I've got a question about objects embedded into a worksheet.

I've been able to successfully embed and operate a RUMBA display screen

via an Excel spreadsheet. What I would like to do is emulate keystrokes to
the screen with the VB code. For example: have a "Log on" button that would
pass the neccessary keystrokes and to the embedded display screen and fill
in ID and password based on data supplied to the excel by the user.

I have found very little in regards to embedded objects. I know that

Excel is not directly running the program (ie. passing telnet commands) but
it seems to me that one would be able to pass simple key strokes(TAB,ESC,
and alphanumerics) to the object. Would this be accomplished with the
"verb" command similar to the connect command sent to the server?