I've used a routine for years to put a plain text string into the clipboard that I can paste into another program such as:

targetData.SetText "This is a plain text string"
targetData.PutInClipboard

When I use this in Excel Office 2013 the data isn't in the clipboard and therefore I can't paste it. This never happened in prior versions.

Under closer inspection I've found that the string does go to the clipboard but as "System String" but not as "Text" or "Unicode Text".

BUT... about 10% of the time it acutally works as it should putting the string into the clipboard as "Text".

Any ideas??

excel vba ms-office clipboard
Edit
Report