Sorry to pile one item of bad news on another, but Microsoft neglected to
make the Office multiple clipboard feature accessible to VBA.

Hi Ben --

Windows offers an API called RegisterClipboardFormat, which effectively
allows anyone to define any random binary structure as a custom format.  In
theory, you could just store these as binary blobs, then put them back on
just as they were.  But you're further complicated by CF_OWNERDISPLAY items,
in which the original application is called upon to draw on demand.

Do you do any plain-vanilla VB?  If so, you might find
http://vb.mvps.org/samples/ClipView to be of interest.  It enumerates the
formats available, and displays those it understands.  You could diddle with
extending it to other formats, to get an idea of how that might be
approached by VB(A).  Another demo, http://vb.mvps.org/samples/ClipEx, may
show you how to approach multiple formats through VBA.

But in the end, saving and restoring the clipboard will be a gargantuan task
that will probably never be 100%.

Sorry...   Karl

Hi Ben,

While Karl and Jonathan gave you correct answers to the questions you
asked, I think you should ask a different question: What end result
are you trying to accomplish, that might be reached without touching
the clipboard at all?

If you have text/graphics/etc. in one document and you need to make a
copy of it in another document or in another part of the same
document, this is possible.

- Define a Range object that encloses the source content. For example:
   Dim Doc1 As Document
   Dim srcRg As Range
   Set Doc1 = ActiveDocument
   Set srcRg = Doc1.Tables(1).Range

- Define another Range object as the destination.
   Dim Doc2 As Document
   Dim destRg As Range
   Set Doc2 = Documents.Add(Template:="MyTemplate.dot")
   Set destRg = Doc2.Range

- Transfer the formatted content of the source to the destination:
   destRg.FormattedText = srcRg.FormattedText

This completely bypasses both the Windows clipboard and the Office
clipboard, which retain anything the user had stored there.

If that technique doesn't help with your task, there are other ways.
For example, you can use the Save As method to make a copy of the
original file and delete from it whatever you don't want, then use the
InsertFile method to bring the remainder into the destination
document.

--
Regards,
Jay Freedman
Microsoft Word MVP        FAQ: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the
newsgroup so all may benefit.

If you want to copy or move formatted text (including objects anchored to
paragraphs within the copied range), within or between Word documents, you
can do so entirely without touching the clipboard, by using the
FormattedText property. Take a look at it in the VBA Help.