Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi Gary,
Thank you for your help but it doesn't solve my problem. What happens is when I run the procedure; 1. It jumps to the other application (this works) 2. Select an inputbox with shortcode ALT+S (this does not work) 3. Paste data with shortcode CTRL+V (this works) The code I use for the ALT+S is; SendKeys "%S", True The code I use for the CTRL+V is; SendKeys "^V", True In essence both lines are the same, though I tried putting one of them in brackets which didn't solve my problem. This probably expalins my situation a bit better. Maybe you, or someone else, can make something out if it 'cause I'm lost here Greetz Basta "Gary''s Student" wrote: If the problem is intermittent, it may be a timing issue. Try putting a DoEvents between your statements -- Gary''s Student - gsnu201002 "Basta1980" wrote: Hi all, I'm using a simple sendkey statement to paste (ctrl v) cell content to another application. However when running the code it sometimes works (I can see the cell content copied and pasted to the application) but most of the times it just jumps from Excel to the other application and stops (so nothing is pasted). Anybody got a clue what might be going on here? Code = Gemini: AppActivate ("CSM - Citrix Presentation Server Client") SendKeys ("{^V}"), True Kind regards, Basta |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sendkeys | Excel Programming | |||
SendKeys Help | Excel Programming | |||
Sendkeys | Excel Programming | |||
SendKeys? | Excel Programming | |||
Sendkeys | Excel Programming |