Reading a copied shape off the Clipboard with VBA

[Visisthebest]

So far I've just used Visio selections a lot but not the clipboard yet. For custom copy-pastes it is very handy to be able to read from it.

If the user copies a shape to the clipboard, what is the best way to read the shape object (reference) off the clipboard? (and of course provide the user a message it if it doesn't contain one Visio shape but something else).

Thank you for your help!

[Paul Herber]

Just do a

Code Select Expand


  thepage.Paste

You can't tell from this what is in the paste buffer, Visio will try to paste whatever is there.

[wapperdude]

With Win10, you can view and copy Clipboard contents via Clipboard History.  See this: https://support.microsoft.com/en-us/windows/clipboard-in-windows-10-c436501e-985d-1c8d-97ea-fe46ddf338c6

I tried it.  It works.

[Visisthebest]

Thank you unfortunately for just reading the clipboard with VBA in Visio and upon paste 'rejecting' (giving the user a message it is not a Visio shape being pasted) the content of the clipboard if it is not a Visio shape, I understand this is not an easy thing to do.

That it unfortunate but can be solved with a custom copy/paste solution within a Visio document context. I read that reading the clipboard used to be much easier with VB6 but in VBA there's more complexity especially if pasting more than just a string.

[wapperdude]

You've probably seen this, not sure it's helpful, (this level of programming above my paygrade):  https://docs.microsoft.com/en-us/office/vba/access/concepts/windows-api/retrieve-information-from-the-clipboard

Don't have a clue as to how you would test if an object on clipboard is a Visio shape.

[wapperdude]

Found this on the forum, imagine you saw this too???  http://visguy.com/vgforum/index.php?topic=2940.0

[Visisthebest]

Thank you Surrogate in the last forum link you shared I saw this link:

http://www.cpearson.com/excel/Clipboard.aspx

That is probably what I need for this super!