I have and Excel 97 - 2003 add-in that under certain circumstances uses the
clipboard. Before using the clipboard I try to save its contents using code
like the following:

Dim MyDataObj As New DataObject
Dim SaveOfClipboard As Variant

MyDataObj.GetFromClipboard
SaveOfClipboard = MyDataObj.GetText()

so that I can restore it when I'm done in case the user has something of
interest to them on the clipboard.

This mostly works OK unless the user has a bunch of data on the clipboard in
which case only the first bit of clipboard data is saved using the above
code.

Is there a better/more complete way of quickly saving and restoring the
contents of the clipboard? I think doing a File | Save of the clipboard
will be too slow so I need something that performs better.

TIA,

josh