Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
SendKeys help (vba macro)
Name: Tony Date: September 2, 2003 at 12:09:15 Pacific OS: win xp home CPU/Ram: 1.8/256
Comment:
Hi.
I'd like to use sendkeys to send to notepad any keystrokes a user enters while in a smarterm session. However, all the examples of this function I have seen all seem to be for sending pre-determined text. Can it be used to send recorded keystrokes?
Name: Chi Happens Date: September 2, 2003 at 19:55:49 Pacific
Reply:
You can send keystrokes, but it is highly inefficient and prone to error (and the target window HAS to be the top most window, so the terminal could not be active while the sendkey command was executing.)
A better way is to use the metafile functions from the win32 api (if you want to record everything that happens), otherwise, you could simply write the keystrokes to a file.
Hope this helps some, Chi Happens
0
Response Number 2
Name: Tony 48 Date: September 3, 2003 at 10:25:17 Pacific
Reply:
Thanks for the comments. I know you don't advise the sendkey method, but do you know what I would need to do to try it? What I mean is what do I type instead of a string for the first argument?
0
Response Number 3
Name: Chi Happens Date: September 5, 2003 at 05:20:54 Pacific
Reply:
You would use a variable. This would contain the information you grabbed from the app that hosts the VBA run-time.
So something like (I don't have smartterm, so this should be considered psuedocode):
Summary: I am in need of assistance of an excel vba macro that i am creating. I am calculating the Canadian dollar by multipling cell "F2" * "G2". However, I am using a loop to do this and I am having troub...
Summary: My VBA knowledge is very basic so looking more for an answer than help with developing the code. I typically have data files with 1 data point per week day that will sometimes be 15 years long. I woul...