View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Mr. m0le[_2_] Mr. m0le[_2_] is offline
external usenet poster
 
Posts: 17
Default Multiple Sendkeys not working... need help to condense code

This will work if i edit what you put to make a variable with the different
key stroke combinations but still not quite what i was looking for. What i
really was try to see if it was possible was to just have one singe command
that used the key stroke a defined number of times.

ie. ("<Tab 20") will enter the tab key for 20 strokes....

Either i'm missing something or the application I'm working with doesn't
allow for this type of command to run and i'm stuck with making variable sets.

"Peter T" wrote:

You may or may not need to include a DoEvents, as GS suggests, but not after
each tab unless a tab is supposed to trigger something else, which I doubt.
You might need the first character as an ESC. Try this to get a feel

Sub test()
Dim sKeys As String
sKeys = "a" & vbTab & "b" & vbTab & vbTab & vbTab & "c"
Application.SendKeys sKeys

' place the cursor just after the appostrophe below and press F5
'
End Sub

Regards,
Peter T

"Mr. m0le" wrote in message
...
I'm using the sendkeys command to send different key strokes to an outside
program already running. Normally this isn't an issue except for this
macro
i'm putting together i have 20+ sendkeys in a row just to get to where i
need
the cursor. I looked in MS Help files and it said to just put a space
between the key and how many strokes but either vb gives me a code error
or
it puts some combination of the word tab and the number used or "tabs"
once
then the number.

here is an example of what I was trying to do;
main.screen.sendkeys ("<tab 20") this just puts the word and number
into
the program instead of the actuall key stroke. I've tried all different
kinds of combinations to get it to work but without luck. Also, the
sendkeys
command for it to work that i've seen so far is to have the key setup like
so
("<KEY").

Anyone have any ideas on how i can condense my many sendkeys commands?