SendKeys

[pvj]

Hi

From Excel I want to activate another window and then send some keystrokes to that window.

From the code below:
1) the window "destination.txt" ALWAYS comes into focus reliably (becomes active) - this does not seem to be a problem.
2) the sent keystrokes are VERY intermittent - sometimes they arrive but mostly nothing goes to the "destination.txt" window.

Please Login or Register  to view this content.

Any suggestions??

[Domski]

If you just want to write to a text file you don't need to use sendkeys.

Dom

[pvj]

The code above is just a test.

What I really need to do is:
1) crunch some conditions in excel
2) bring another program's window into focus
3) send 'alt'+'b' to that other program - which will then perform another task

Right now I'm just trying to get the code to work.

Thanks for any help

[Domski]

I know it's sometimes worth adding pauses to your code when using sendkeys. I've never really used them much though I have to admit.

Dom

[pvj]

I had thought of that - but I can't find any commands/syntax for pause / sleep / wait etc

how do you introduce a pause into the code???

Thank you for your help

[pvj]

I had thought of that - but I can't find any commands/syntax for pause / sleep / wait etc

how do you introduce a pause into the code???

Thank you for your help

[pvj]

I had thought of that - but I can't find any commands/syntax for pause / sleep / wait etc

how do you introduce a pause into the code???

Thank you for your help

[Domski]

This will pause for a second:

Please Login or Register  to view this content.

Dom

[pvj]

Thankyou - that seems to work very well.

I'm sorry to say that I missed that command in the help.

Do you know of a way to pause for less than a second???
The 'timer' function (according to the help) does fractions of a second but the help doesn't give an example of less than a second.

Thankyou for your help.

[Domski]

I think you can use a Sleep API to pause for less than a second.

Pop this at the top of your module:

Please Login or Register  to view this content.

and then you can use it like this where 1 second = 1000:

Please Login or Register  to view this content.

Dom

[pvj]

Perfect - it works great.

Thank you for your help

Now I can solve the real problem.