clipboard - backup and restore

[softie]

Gentle Users,

My VB6 application programmatically uses EXCEL. Every time I direct it
to Copy to Clipboard, it wipes out All contents of the Clipboard. This
fact is well known from discussions in the ms.public groups.
Apparently, it not acceptable behavior for an app to replace contents
of the clipboard with out asking the users permission. I copy to
clipboard so frequently, that asking-for permission is out of the
question.
Backing up and restoring the clipboard is, of course, the answer, but
there seems to be so many data types that programming it myself
appears beyond my capabilities.

My 2 questions are:
I am looking for a dll to include in my app that saves and restores
the clipboard on command.
1. Does anyone know of such a product?
Failing that, I suppose that I will have to put out a request for
programmers to bid on it.
2.Has anyone had experience with programmers-bidding for jobs from the
far corners of the internet?

tia
softie

 

[Peter T]

I admire your intentions !

I don't know of any dll to back up and restore the clipboard. Depending on
what's in the clipboard the task might be relatively straightforward or
extremely difficult.

I don't want to suggest don't bother looking for a solution (I'd like
similar myself) but it's worth noting in Excel, perhaps more than any other
app, the clipboard persists in a very transitory manor. It's easily lost,
simply by pressing Esc or following any one of a number of normal user
actions. IOW, the user normally needs to use the clipboard as the next
action and not expect the contents to last indefinitely.

Apart from the clipboard, the another issue that's less than satisfactory is
complete loss of the clipboard as soon as the interface is programmatically
changed.

If you are only using Excel for your own purposes automating your own
(hidden) instance will preserve some aspects of the clipboard, but not all.

If you ever do find what you are looking for do post back !

Regards,
Peter T