Reading the type of content in the clipboard.

[Kenton]

Is their a way to “read†the type of content in the clipboard?

The output of the macros should be one of the following:

The clipboard contains formatted text
The clipboard contains a MS Excel range
The clipboard contains a MS Excel Graph
The clipboard contains a Bitmap picture
And so on….

The idea is to "interpret" the content of the clipboard before it is pasted

Thank You

 

[Cindy M.]

Hi Kennton,

There's nothing in the Word or Office object models that can do
this. It can be done with the WindowsAPI, but I lost the code sample
I had a few years ago, when Normal.dot went south.

You might be able to get something in a classic VB newsgroup.

Is their a way to “read†the type of content in the clipboard?

The output of the macros should be one of the following:

The clipboard contains formatted text
The clipboard contains a MS Excel range
The clipboard contains a MS Excel Graph
The clipboard contains a Bitmap picture
And so on….

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17
2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow
question or reply in the newsgroup and not by e-mail