I'm trying to create a macro that:
- Copies a field in Excel
- Moves 2 spaces to the left
- Appends the text I specify to the clipboard data and pastes it in a new field
When I run the macro it only pastes the copied data with no appended text.
In the example it should be pasting "My Text23" (if 23 was copied to the clipboard).
Here's what I have:
Append to Clipboard and Paste.kmmacros (3.2 KB)
I also tried setting it to this:
Also tried using a named clipboard:
Use a Named Clipboard.kmmacros (4.0 KB)
The strange thing is if I use "Display Text In A Window" it gives me the desired result:
Change it to this:
And this is the result:
I found a workaround by showing it in the window, selecting all and then copying, hitting enter to close the window and THEN moving and pasting The problem is that it's reformatting the text with a different font now. . It shouldn't be this difficult
Testing this it only works half the time. I've tried putting pauses in but it's finicky...
I figured out a way to do this. It was the "Paste" command that was messing things up. When I switched to "Type" it worked. Also the Repeat on the arrow keys was glitchy. I had to do single versions of those.
I added a user input at the beginning to keep it configurable. I'm posting it here for any one who wants it