Hello all, here is my problem. Frequently I paste text from OCR'd sources. I wrote a macro to find and replace all paragraph marks within a selection (in MS Word) with spaces. So long as I don't copy more than 1 paragraph, the text wraps properly and is formatted as one paragraph, not a bunch of separate lines.
However, currently I need to:
1. copy
2. paste
3. highlight text
4. run macro
I would like to replace that with:
1. copy
2. run macro
Step 2 would have a keyboard shortcut. The macro would be my existing macro, but would operate on the clipboard contents instead of text that I have pasted and subsequently highlighted in Word.
Does anyone know how to perform a find and replace in VBA on the contents of the clipboard?
Bookmarks