Hello,
I have tried in several ways to simply copy text to the clipboard, but I can only make the content viewable within Excel itself. Notepad returns empty and Word returns two unrecognizable characters. What could be happening? Is there another alternative? (by API only found to clean)
Code
Dim Object_ As MSForms.DataObject
Set Object_ = New DataObject
Object_.SetText "Text", 1
Object_.PutInClipboard
Object_.GetFromClipboard
Range("A1") = Object_.GetText(1) 'works perfectly, but only within Excel
Thank you, Wilker.