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 aint it: We are messing with the thing that makes its own copies of things last set to go on the 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 incidences 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 application its running in. 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…

)

Anyways, manipulating that Office Clipboard 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]