realtebo

Excel: Send {"^C"} is ignored

3 posts in this topic

#1 ·  Posted (edited)

Prologue: PLEASE DO NOT TELL ME TO USE EXCEL UDF. I really need to do some complex things with saltuary user interactions.

all is working (included GUI and user interactions) UNTIL i need to simply automate a copy/paste. I need to do this in this way, please :sweating: respect my will, simply, if you can and if you want, reply to my question 'as is'

I'm on Excel, opened by Autoit

I use {DOWN} key to goto a cell a5.

I send "^C" to copy the cell, then move to right and paste

Simply it doesn't work.

I noticed that ^C is ignored.

I've already tryed this

ClipPut("")
Send("^c")
Do
    Sleep(100)
Until ClipGet()

without success. (The gui is frozen, because clipGet never give results)

Is there a way?

Edited by realtebo

Share this post


Link to post
Share on other sites



#2 ·  Posted (edited)

Try it like this do the msgbox popup?

Sleep(5000)
ClipPut("")
Do
    Sleep(100)
    Send("^c")
    $clip = ClipGet()
Until $clip
MsgBox(0,'',$clip)

tested with

Sleep(10000)
ClipPut("")

Send("{DOWN 4}")
Send("^c")
Send("{right}")
Send("^v") 

no problems

Maybe you just need some sleep factor before copying data.

Better that you post script that can reproduce problem, you say "I'm on Excel, opened by Autoit" and we don't have code for that to test with, so post that code that is causing you the problem (or smaller code that can replicate problem).

Edited by bogQ
1 person likes this

TCP server and client - Learning about TCP servers and clients connection
Au3 oIrrlicht - Irrlicht project
Au3impact - Another 3D DLL game engine for autoit. (3impact 3Drad related)



460px-Thief-4-temp-banner.jpg
There are those that believe that the perfect heist lies in the preparation.
Some say that it’s all in the timing, seizing the right opportunity. Others even say it’s the ability to leave no trace behind, be a ghost.

 

Share this post


Link to post
Share on other sites

You're right !

I added some

Sleep(500)

 

Before copy and before past, but, also, used ^{INSERT} and +{INSERT} instead of Ctrl-c And Ctrl-v .

Magically it works !

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now