DataObject/Clipboard coming out with strange characters

[quekbc]

Hey guys, hope you guys can shed some light on some issue I've been facing.

I have this simple code here:

Please Login or Register  to view this content.

This code has been working fine for me until fairly recently, but I don't know what's causing the issue.

The problem I've been having is that, whenever I push stuff into clipboard (i.e. run the macro ExcelForumTest) - when I paste it (CTRL V), it spits out 2 odd characters ASCII code 63 or square boxes in Excel, question marks when pasted in VBE, nothing in Notepad.

When I try to analyse via VBA using the "ExtractFromClipboard" macro, I am faced with the same issue.

My current system:

Windows 10 Pro
Intel Core i7
8.00 GB RAM
64-bit Operating System
Problem persists in all Excel 2007, 2010, and 2013 (32-bit).

I've repaired Excel once - which worked for maybe 5 minutes, then it reverted to the strange characters again.

Happy to hear any insights anyone here might have.

[dominicb]

Good afternoon quekbc

Hmmmm, sure is strange. I wasn't going to answer this, as I don't have a solution, but nobody else has responded, it's 6 hours old, so I'll offer my thoughts, some encouraging words ... but no answer.

I've tested this and it works OK on my system - you forgot to mention to other users that you need to set a reference to the Microsoft Forms 2.0 Object Library. My system is Excel 13, Windows 7 - both 32 bit.

I suspect that Windows is the issue, as the Clipboard, as you're no doubt aware, is a Windows object not an Excel (or VBA) object. This would be borne out by the fact that you have tried several different version of Excel which all react the same - it just doesn't seem right that after running Excel repair it works OK, however briefly that may be.

In your project do you "have" to utilise the clipboard? Can you not just store the values / strings as variables and populate fields that way?

DominicB

[quekbc]

Thanks for the response DominicB.

Yes, you are right, I did forget to mention the need to add Forms 2.0 reference to VBE. My bad.

I suspected as much, but thought I'd ask here in case someone else faced the same issue and perhaps have a solution.

I don't technically "have" to utilise the clipboard - but it is useful in my field of work. I constantly work with multiple instances of Excel and having this code helps me transfer information across instances of Excel.

Thanks again for the response. I shall have to find a way to work around this.

[shg]

Rattling around in my brain is that this is a recent (W8?) issue with the clipboard, and romperstomper knows of a workaround. I'll ask if he will grace us with his presence.

[Izandol]

It is bug from Windows 8 on. It is better to use Clipboard API - please read answer with links on MSDN forum: https://social.msdn.microsoft.com/Fo...d?forum=isvvba

[quekbc]

Thanks Izandol! Seems like I'm not the only one with that issue.

I'll have a look at using the clipboard API