25. februar 2008 - 15:43Der er
14 kommentarer og 1 løsning
Hjælp til SendKeys - Kopiering
Hej Alle,
Jeg sidder med en opgave hvor jeg skal bruge access til at hente noget tekst fra et andet program. Jeg bruger følgende kode:
SendKeys ("%{TAB}")
PauseTime = 1 Start = Timer Do While Timer < Start + PauseTime DoEvents Loop
SendKeys ("%R") SendKeys ("A")
PauseTime = 1 Start = Timer Do While Timer < Start + PauseTime DoEvents Loop
SendKeys ("^(C)")
Det den skal er at TAB'e over til mit andet program. Gå ind i Rediger menuen, Trykke A (for så at markere alt) og trykke CTRL + C for at kopiere det markerede til mit clipboard. Jeg ved at jeg kan gøre det manuelt så den del virker. Og med det her system går den over, får markeret det hele og så forsvinder markeringen (Dette sker også når jeg manuelt kopierer) - Men når jeg så går over i notepad eller lign så har den ikke kopieret noget.
Er der nogen der kender grunden til dette eller har en bedre løsning?
I have ways to test that I am at the right program. So that shouldnt present a problem. But to make it easier, do you know how to check the title of the active window through VBA? The timer delays are to halt the sendkeys, so if there is some "lag" in the program i'm switching to. So the timers give me program time to load before sending the next "batch" of keys.
No the active window - nevermind. The real problem is actually the CTRL + C not working. It's really annoying cause I just can't see any reason why it shouldn't work.
Maybe ist time to replace it which will maybe remove the need for using sendkeys. Or maybe it is possible to alter the program so what ever your trying to copy to Access is done from there.
Well the program is a program bought for a very large company and can therefore not be changed. I guess I'd have to scram that idea alltogether. Thank you for trying to help.
Synes godt om
Ny brugerNybegynder
Din løsning...
Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.