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!
