| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can Sendkeys be used to send a selected no. of characters in a sin
Say this is the data I have contained in a single cell c1:
PT NR 25 M (14h-20h),Tu (8h-14h45),W (8h-14h45),Th (8h-14h45),F (8h-14h45),Sa (8h-16h) Could I configure a sendkeys statament to send say the first 11 characters/spaces, say (up as far as the first bracket for instance) ? The reason is that I want to input the code:Application.SendKeys "{{}" to send an open bracet to this cell followed by, say: 14h-20h, followed by a sendkeys statement for a closed bracket? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Can Sendkeys be used to send a selected no. of characters in a sin
What exactly are you trying to accomplish?
Barb Reinhardt "Zakynthos" wrote: Say this is the data I have contained in a single cell c1: PT NR 25 M (14h-20h),Tu (8h-14h45),W (8h-14h45),Th (8h-14h45),F (8h-14h45),Sa (8h-16h) Could I configure a sendkeys statament to send say the first 11 characters/spaces, say (up as far as the first bracket for instance) ? The reason is that I want to input the code:Application.SendKeys "{{}" to send an open bracet to this cell followed by, say: 14h-20h, followed by a sendkeys statement for a closed bracket? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Can Sendkeys be used to send a selected no. of characters in a sin
Hi,
I'm not sure what your using sendkeys for. To build the string you require use this mystring = "{" & Trim(Left(Range("C1").Value, 11)) & "}" After that I'm not sure what you want to do with the string Mike "Zakynthos" wrote: Say this is the data I have contained in a single cell c1: PT NR 25 M (14h-20h),Tu (8h-14h45),W (8h-14h45),Th (8h-14h45),F (8h-14h45),Sa (8h-16h) Could I configure a sendkeys statament to send say the first 11 characters/spaces, say (up as far as the first bracket for instance) ? The reason is that I want to input the code:Application.SendKeys "{{}" to send an open bracet to this cell followed by, say: 14h-20h, followed by a sendkeys statement for a closed bracket? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I send selected cells in an e-mail using excel 2007? | Excel Discussion (Misc queries) | |||
| Send parameters in worksheet button 255 characters | Excel Programming | |||
| Send sheet to selected distribution list using VBA | Excel Programming | |||
| About send email of selected range in Excel | Excel Programming | |||
| How to Send Selected Data thourough Mail or message. | Excel Discussion (Misc queries) | |||
Hybrid Mode
