I have to paste a list of values one at a time into a web browser search field with each value followed by a Down Arrow and a Return. I searched this forum and found some examples. I made this. I kept it simple by doing the copy of the Google Sheets column myself, switching to the browser window with the Search field, and then triggering the macro. It pastes the clipboard as many times as there are values on the clipboard, but each paste is the entire set of values, not just one at a time. What did I do wrong?
What you did wrong is that you used the "Paste" action which pastes the entire clipboard. What you should be doing is pasting or typing the value "local_Line" instead, which is iterating through the lines of the clipboard, the way you wrote your macro. There's probably more than one way to do that. May I suggest this method:
I didn't test it, but I'm 90% sure this is your problem.
Bingo! Thanks so much. After finally finding a way to generate the report that I needed, which turned out to be way more complicated that it should be, I wasn't looking forward to copy-and-pasting 400+ values every time I needed to run it. I hadn't needed to use Keyboard Maestro in at least 10 years even though I had been keeping it up-to-date. However, when I went to use it today I noticed that I had missed the v11 update. It was worth the $26 update to avoid 1.5 hours of copy-and-paste.
1 Like
Only 1.5 hours? My KM's About pane says:
Time Saved: 3575 years
And that's only on this Mac, which I have had for only a year, I think.
1 Like