Sendkeys
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
|