What i was mainly after was a one-click button for:



2) Paste special -> paste link: -> Unformatted text -> Ok.

All the three macros seems to copy the content from excel into word but the "Link" is not copied with the content, into MS word.
When i manually press Paste special -> paste link: -> Unformatted text, i get the number from the excel sheet copied into Word and afterwards when i right click the it, i get the "Update Link" and "linked worksheet object" options indicating that the link from excel is there.
When i use either of the macros (or any other macros i have found) they only paste the value of the cell i copied and not the link.