how to read things inside any window

[onidarbe]

Thanks for your help.
I'm still trying to solve the loss of the cut/copy/paste when using code like .calculate or .calculation
There are already some options, but they all have there restrictions. Most only keep the values to copy. Others use pasting the copied range to extract the address from the formula, but that doesn't work with "cut"!
Using the previous selection as the cut/copy range together with GetClipboardSequenceNumber to know there is an new cut/copy is the best way, but that doesn't work when using undo/redo. Because last selection isn't the cut/copy range!

So I was thinking on checking and counting undo.redo and hold the according cut/copy range in memory. I could just count the differences with the previous amount of unod/redo's but this doesn't work when redo the last one. Because the undo/redo amount is the same as typing in something new and thereby adding an undo and deleting the last redo.

Now I'm trying to read the office-clipboard ("bosa_sdm_XL9", "Collect and Paste 2.0") it's there but I can't seen to get the data from the screen in the code. So where can I find out how to read these "windowless label controls" ?

thanks

[Bonnie West]

Now I'm trying to read the office-clipboard ("bosa_sdm_XL9", "Collect and Paste 2.0") it's there but I can't seen to get the data from the screen in the code.

If Spy++ cannot highlight any of the controls inside that Clipboard window anymore, then they most likely are windowless controls.

So where can I find out how to read these "windowless label controls" ?

I don't know if there's any API that can manipulate windowless controls. Sorry.

You may want to try searching MSDN though. On the first page of the search results, I found this pretty short description of Windowless Controls.