Copy text (form textbox) to clipboard - symbols

Hi everyone,

So, simple thing: copying text from a textbox to clipboard using VBA. This has been working nicely but I've moved to a Win 10 64-bit & Office 365 ProPlus 32-bit (company laptop) and I'm in hell now!

Every time I copy something I now get two damn symbols (like this ￿￿, or question marks if pasted to ms word).
I've searched and as far as I understand there is a workaround using API... but I look at that and it's like quantum physics to me!

This is the code I'm using (users press a "copy" button):

Please Login or Register  to view this content.

I look at a code using API (like this one https://stackoverflow.com/questions/...ndows-10-issue and I can't figure out where or how I tell this thing to get my text from the textbox called "TextForm".

Can someone please enlighten me?
Thank you.

Hi no_Fate,

Your code uses 'Early Binding'. Before you go to Alpha's API solution, try the equivalent of your code using 'Late Binding':

Please Login or Register  to view this content.

For a discussion (and examples of) 'Early Binding' vs. 'Late Binding' see https://peltiertech.com/Excel/EarlyLateBinding.html

I prefer 'Late Binding' because it does not require a 'Library Reference'. One of the disadvantages of 'Late Binding' is that 'Intellisense' DOES NOT work.

For more information about 'Intellisense' see:
https://colinlegg.wordpress.com/2012...isense-part-1/
https://colinlegg.wordpress.com/2012...isense-part-2/

Lewis

Good afternoon,

Thank you Guys! @LJMetzger, because it was smaller, I've tried you method but unfortunately with the same result. Maybe I was doing something wrong.

@AlphaFrog, that is working perfectly, thank you!

Originally Posted by xlnitwit

FYI, no you weren't. The issue is a bug with the DataObject, so changing the binding context would not help in this case. I believe that the issue only occurs when you have something selected in a Windows Explorer window and you are using Windows 8 or later, though I don't know why.

Wow... that would explain why "sometimes" it worked (which was driving me nuts, by the way). I've never noticed that pattern. What a weird bug!

Thank you xlnitwit.