after upgrade to windows 10 vba dataobject.putinclipboard stops working
Posted on 2016-07-31
after upgrading windows 7 pro to windows 10 pro the following code does not work in excel 2010 word 2010 or outlook 2010 . I have found other forums that confirm this as a problem and give workarounds using other APIs, but I really hate searching dozens of my programs to replace simple code with complicated APIs.
I have tried repairing office 2010 pro, but that did not solve the problem.
Does anybody have a fix? If not does anybody have a computer where this works with windows 10 and excel 2010 ?
Dim Dto As New DataObject
mystring = Dto.GetText
MsgBox " this shows that the clipboard contains <" & mystring & ">. BUT if you paste the clipboard into notepad, you get ??"