C
Craig
I frequently find myself typing chunks of text that, once I’ve finished, I
realize I’d like to save for repeated future use. But since I didn’t have the
macro “recorder†turned on when I was typing, there is no macro created. I’ve
tried to remedy this by by copying the text and then pasting it into a blank
page with the recorder feature running.
For example, if I type “Now is the time for all good men to come to the aid
of their party,†then copy that text, turn on the macro recorder, paste that
text into the macro, and then turn off the recorder, I have created a great
little macro that reads “Now is the time….â€
However, the very next time I copy any other text (“The quick brown fox
jumped over the lazy dogâ€), regardless of my reason for doing so, my “Now is
the time†macro changes to “The Quick brown fox…â€, or whatever other words I
have copied to my clipboard. In effect, the macro I created is a macro that
ALWAYS picks up whatever I have pasted to my clipboard, not a macro that
repeats the same desired text over and over.
Any thoughts about how I can create a macro from text I have already typed?
Thank you very much for any insight!!
realize I’d like to save for repeated future use. But since I didn’t have the
macro “recorder†turned on when I was typing, there is no macro created. I’ve
tried to remedy this by by copying the text and then pasting it into a blank
page with the recorder feature running.
For example, if I type “Now is the time for all good men to come to the aid
of their party,†then copy that text, turn on the macro recorder, paste that
text into the macro, and then turn off the recorder, I have created a great
little macro that reads “Now is the time….â€
However, the very next time I copy any other text (“The quick brown fox
jumped over the lazy dogâ€), regardless of my reason for doing so, my “Now is
the time†macro changes to “The Quick brown fox…â€, or whatever other words I
have copied to my clipboard. In effect, the macro I created is a macro that
ALWAYS picks up whatever I have pasted to my clipboard, not a macro that
repeats the same desired text over and over.
Any thoughts about how I can create a macro from text I have already typed?
Thank you very much for any insight!!