Thread: Sendkeys
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Basta1980 Basta1980 is offline
external usenet poster
 
Posts: 102
Default 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