LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 17
Default Multiple Sendkeys not working... need help to condense code

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?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
SendKeys not working for some program Oshikawa Excel Programming 0 April 28th 09 08:19 PM
condense code for gridelines SITCFanTN New Users to Excel 1 June 30th 06 02:31 PM
Condense Code Nigel Excel Programming 2 December 22nd 05 11:59 PM
SendKeys {HOME} not working RB Smissaert Excel Programming 9 December 11th 03 01:27 AM
appactivate sendkeys not working with accelerator RB Smissaert Excel Programming 4 August 12th 03 08:31 PM


All times are GMT +1. The time now is 08:13 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"