clipboard change as event in order to automatically activate my procedure

Like (0) Share

Report

Posted on 5 Nov 2021 11:22:18 by Alain_D

Bonjour

I want to automatically copy to Excel file new content of clipboard each time there is a new "data" into the windows clipboard

My procedure works perfectly to copy new content to the right cell to Excel, but I can't find the solution to automate the process

Each time when the event "new data detected in windows clipboard" then "activate automatically my procedure"

Is there a function that will execute procedure when the event "new data added in clipboard" is detected ???

thanks for your help

All responses (3)

Answers (0)

Alain_D 2 on 10 Nov 2021 at 13:02:41

Like (0)

Report

Re: clipboard change as event in order to automatically activate my procedure

Hello

sorry I havent had any time with my new windows pc after 4 years with android

tasker on android allow to test a change on android var event to trigger a process depending on the test

i will test it later as soon......with your solution....

thanks a lot
MichaelAnnis 5,721 Super User 2025 Season 1 on 05 Nov 2021 at 14:16:42

Like (0)

Report
Re: clipboard change as event in order to automatically activate my procedure

I agree with Henrik. That was the original answer I had, but have two more options below. If you want to have a PAD constantly running, you could have a loop like this:
Set %PreviousClipboardText% to "Never_gonna_see_this_text"
Set %IndexRow% to 1
Open Excel (whatever file you want, or a new one)
Loop 1 to 999999 increment of 1
Get Clipboard Text to %ClipboardText%
If %ClipboardText% does not equal %PreviousText%
Write to Excel %ClipboardText% to %ExcelInstance% at Column A, Row %IndexRow%
Set %IndexRow% to %IndexRow + 1%
End (IF)
End (Loop)

Alternatively, this might be more effective:

Create the same loop as above, but after Set %IndexRow% to %IndexRow + 1%, have a message box that you simply have to click OK. This message box would stay on top of everything you are working on, and you simply would hit OK to activate the next loop. So instead of copy here, go to excel, paste, go back to what I was doing, copy again...it would just be copy, click OK, copy, click OK. That way, you are dictating when there is something to copy, and you don't have PAD just sitting in this loop, it will be paused between each time you click OK.

Lastly, you may be able to change the pause/go hotkey for the loop. If you can change that to Control + C, and Windows still picks up the Copy command, you could be telling it to do both at the same time. You would immediately copy, and PAD would start another loop. For this method, I would put a pause command where I suggested putting the message box.

Hope one of these work for you. Best of luck!
Henrik_M 2,006 Super User 2024 Season 1 on 05 Nov 2021 at 13:31:52

Like (1)

Report

Re: clipboard change as event in order to automatically activate my procedure

No, that sounds impossible.

Unless you want to constantly have a desktop flow running in a loop, where it checks the clipboard content...