Hello all, I want to write a macro in VBA to do the following:
A user has two MS Word documents open with text in both. The user first copies information from document one onto the clipboard. Then, the user goes to document two and places his cursor in a preferred location. Upon running the macro, the information will paste into the second document as a hyperlink back to the first document where the original information was copied.
I started with the attached code. It only works some of the time. Other times, I just get errors saying the clipboard is invalid or empty.
Any help is greatly appreciated!
.PasteSpecial Link:=True, DataType:=wdPasteHyperlink