Quote:
Originally Posted by AlanCantor
Hi Charles,
This works nicely, too. I was able to modify your code so the table, sans hypertext, is copied to the clipboard. Thank you!
The reason I want to strip hypertext from the clipboard, rather than from the table, is that the text, after it's copied, doesn't get pasted. I assign whatever is in the clipboard to a text variable, and parse it. But I know nothing about the metadata associated with the hypertext, so I can't delete it. I was hoping there might be a way to unlink hypertext from the clipboard before I assign the clipboard to a variable.
|
There may well be a way. However, I do not know it and suggested a workaround.
- After copying, create a new blank document.
- Paste into that document.
- Run the macro to strip out the hyperlinks.
- Copy the modified text from the new document.
- Close the new document without saving.
At this point, the clipboard contains the text without the hyperlinks.