Hi,
I am using this simple code to put data in clipboard that will be used late in another application (Ctrl + V) to paste data.
But for some user it dos'nt work 100% the time, there are days it works there are other days it wont. I dont understand why. I searched on google and saw some people had similar issue but haven't found any solution.
Is there anyway to fix it or is there another method that is more reliable to put data in Clipboard ?
Thanks,
Also tried thsi with same issue:
I am using this simple code to put data in clipboard that will be used late in another application (Ctrl + V) to paste data.
But for some user it dos'nt work 100% the time, there are days it works there are other days it wont. I dont understand why. I searched on google and saw some people had similar issue but haven't found any solution.
Is there anyway to fix it or is there another method that is more reliable to put data in Clipboard ?
Thanks,
Code:
Msg = Range("E3").Value
Dim DataObj As New MSForms.DataObject
DataObj.SetText Msg
DataObj.PutInClipboard
Also tried thsi with same issue:
Code:
Dim MSForms_DataObject As Object
Set MSForms_DataObject = CreateObject("new:{1C3B4210-F441-11CE-B9EA-00AA006B1A69}")
MSForms_DataObject.SetText Msg
MSForms_DataObject.PutInClipboard
Set MSForms_DataObject = Nothing