Tests Copying pasting Cliipboard issues

**DocAElstein** · 03-09-2024, 10:11 PM

**DocAElstein** · 03-13-2024, 04:13 PM

xnm ccy cy

**DocAElstein** · 03-13-2024, 04:13 PM

xvndvndvn

**DocAElstein** · 03-13-2024, 04:13 PM

hcasscs

**DocAElstein** · 03-20-2024, 04:38 PM

Hi
I thought it might be of general subject interest and helpful for future reference to mention that we had this exact same question from Yasser in 2019 ,
(although it took us most of that Thread to figure out what he wanted, which was to get VBA to do something like when we manually click that Clear All Button . In the meantime we got a bit more insight into what The Windows Clipboard is all about: It seems we are not strictly playing with a clipboard, since there is only one, and that thing often referred to as th Office Clipboard aint really part of the The Windows Clipboard : We are messing here with the thing that makes its own copies of things last set to go on The Windows Clipboard , (in many cases, especially in Excel, those things never get there, ( there in the real clipboard) until a Paste. ) Also if you have multiple versions of Office open, they will all make their own independent copy of what is sent or set to be sent to the windows clipboard, but all our coding attempts will just clear the stuff in the version its running in. That last bit is perhaps an important point that might be worth saying again a bit differently: Say I have Excel open from Office 2003, and I have word open from Office 2007. I then go somewhere, anywhere, does not have to be anywhere in particular other than in Windows and I copy a word, Alan. That now appears in two list, one in each of the open Office versions:
But if I use just one of the two Clear All Buttons, then it only is cleared from that list. So that is telling us again that each of the two things is monitoring and making its own copy of what is going or set to be going to The Windows Clipboard
Arguably then, perhaps we are playing with something that is more like a straight forward simple clipboard than the one and only actual windows clipboard itself is. It is in fact, referred to as the Office Clipboard, even by Microsoft. We have the better insights / insighters here…

What it is a clipboard like thing, and we can have as many as we have office versions on our computer. So there is no single Office Clipboard in the way that there is a single windows clipboard. I am not trying to be annoyingly pedantic, I just think it helps to understand things a bit better, which might lead to better solutions.

Anyways, manipulating that Office Clipboard thing in any direct way with VBA I have yet to see done. I think throughout we are concentrating on just getting that button clicked, at some higher accessible interface level, which is what Mike’s ( SpeakEasy’s ) insight is telling us about I guess?
_._________
Back in 2019 we had a few of the mysterious API codings offered, big ones, most of which I think seemed to come from an Arab guy, who is an Author of a lot of these API thingies, Jaafar Tribak. I fiddled around, admittedly blindly, and got a version to work across Office versions 2003 2007 2010, (which was all I had at the time). It’s still was mostly Jaafar Tribak’s coding and was/am no the wiser how it works. In the light of this Thread and also just re reading all the previous stuff, I did some minor changes/ updates, and this is probably "my" latest attempt – its still mostly from the mysterious big versions from Jaafar Tribak)

We hit a brick wall back then, in 2019, as we could not get it working in Office 2016. So Yasser went off to mrexcel.com and got some interesting info from Jaafar Tribak , who tried but failed still to get it working in Office 2016. (Back then he only had Office versions 2007 2010 and 2013)
(That mrexcel thread has got a bit messed up by a forum software update, so I tried to make a repaired summarized copy of it pulling out the important bits here )

Back in 2019, the persistent error ( In Office 2016 ) with "my" coding and a few of the bigger codings offered by Jaafar Tribak at mrexcel was "Object doesn't support this property or method 'Error 438' " at the line
Call oIA.accDoDefaultAction(vKid). For all previous Office version, that code line did not error, and that is the code line in the previous coding that does the clearing, that is to say does the same as manually clicking that Clear All button in the Office Clipboard viewer, ( which incidentally must be open for any of the codings so far to work. I noticed on my recent review that it does not always get opened as it should by the previous codings, and I added a small mod that seems to overcome that problem)
The only reason for this Office 2015 problem at the time that Jaafar Tribak could think of was that the hierarchy of the accessible buttons in the office clipboard had changed for Office 2016. My thinking was that something quirky was going on as we weren’t getting at any kid from the relevant interface out of the COM wrapper that should have that interface of the accessibles……
_.____________

In the meantime I have got some 2013 Office versions and one 2016 versions, so I thought I would
_ a) take a re look at the previous Threads
and
_b) a look at this one( the one I am writing in now) …..

_a) I confirmed all the previous findings, which was that the codings from 2019 were OK for Office up to 2013 and then the mentioned problem was also what I got in my Office 2016
https://www.excelfox.com/forum/showt...ge11#post17966
https://www.excelfox.com/forum/showt...ge11#post17968
https://www.excelfox.com/forum/showt...ge11#post17969

Now _b ), some comments and findings as a result of this new Thread ….. maybe in the next post……

**DocAElstein** · 03-20-2024, 04:38 PM

later

**DocAElstein** · 03-23-2024, 11:33 PM

Later

**DocAElstein** · 03-23-2024, 11:33 PM

Later

**DocAElstein** · 04-22-2024, 10:18 PM

later

**DocAElstein** · 10-06-2024, 02:53 PM

-

Spare post for later related to these current posts

https://www.excelfox.com/forum/showt...ll=1#post24317
.

https://www.excelfox.com/forum/showt...-issues/page56
https://www.excelfox.com/forum/showthread.php/2824-Tests-Copying-pasting-Cliipboard-issues/page56
https://www.excelfox.com/forum/showt...ge56#post24317
https://www.excelfox.com/forum/showthread.php/2824-Tests-Copying-pasting-Cliipboard-issues/page56#post24317
https://www.excelfox.com/forum/showt...ll=1#post24317
https://www.excelfox.com/forum/showthread.php/2824-Tests-Copying-pasting-Cliipboard-issues?p=24317&viewfull=1#post24317 [/size]