Good morning, all,

I notice that if I copy something to the clipboard, then alter any of the
application or window display settings, the contents of the Clipboard are
lost.

This happens in "Normal" Excel too, as well as in VBA - can anyone suggest a
way of somehow preserving the contents of the clipboard?
I'm using Excel 2003.

Thanks in advance

Pete

don't copy to the clip board until the next action is to paste. Make your
changes before copying.



--
Regards,
Tom Ogilvy

"Peter Rooney" wrote in message
...
Good morning, all,

I notice that if I copy something to the clipboard, then alter any of the
application or window display settings, the contents of the Clipboard are
lost.

This happens in "Normal" Excel too, as well as in VBA - can anyone suggest
a
way of somehow preserving the contents of the clipboard?
I'm using Excel 2003.

Thanks in advance

Pete

Tom,

You helped me out with this one first time round - only problem is, in my
latest app, the problem isn't occurring any more, but the code is basicslly
the same!

I'll have to rework it in the manner you suggest.

Thanks

Pete



"Tom Ogilvy" wrote:

don't copy to the clip board until the next action is to paste. Make your
changes before copying.



--
Regards,
Tom Ogilvy

"Peter Rooney" wrote in message
...
Good morning, all,

I notice that if I copy something to the clipboard, then alter any of the
application or window display settings, the contents of the Clipboard are
lost.

This happens in "Normal" Excel too, as well as in VBA - can anyone suggest
a
way of somehow preserving the contents of the clipboard?
I'm using Excel 2003.

Thanks in advance

Pete

If it is in VBA you could store the clipboard in a variable and restore from
that after your code.

RBS

"Peter Rooney" wrote in message
...
Good morning, all,

I notice that if I copy something to the clipboard, then alter any of the
application or window display settings, the contents of the Clipboard are
lost.

This happens in "Normal" Excel too, as well as in VBA - can anyone suggest
a
way of somehow preserving the contents of the clipboard?
I'm using Excel 2003.

Thanks in advance

Pete

That would be ideal, if you happened to know how I reference the clipboard
contents in VBQ!

Thanks!

Pete



"RB Smissaert" wrote:

If it is in VBA you could store the clipboard in a variable and restore from
that after your code.

RBS

"Peter Rooney" wrote in message
...
Good morning, all,

I notice that if I copy something to the clipboard, then alter any of the
application or window display settings, the contents of the Clipboard are
lost.

This happens in "Normal" Excel too, as well as in VBA - can anyone suggest
a
way of somehow preserving the contents of the clipboard?
I'm using Excel 2003.

Thanks in advance

Pete

It is quite easy with the Windows API. Do a search on Google for
something
like setclipboard or getclipboard and Excel and you will have the code
in no time.
If you have VB6 or if you know somebody who has you could make a very
simple
ActiveX dll that does the same. It is easy in VB6 as that has a
Clipboard object.

RBS


Peter Rooney wrote:
That would be ideal, if you happened to know how I reference the clipboard
contents in VBQ!

Thanks!

Pete



"RB Smissaert" wrote:

If it is in VBA you could store the clipboard in a variable and restore from
that after your code.

RBS

"Peter Rooney" wrote in message
...
Good morning, all,

I notice that if I copy something to the clipboard, then alter any of the
application or window display settings, the contents of the Clipboard are
lost.

This happens in "Normal" Excel too, as well as in VBA - can anyone suggest
a
way of somehow preserving the contents of the clipboard?
I'm using Excel 2003.

Thanks in advance

Pete

Here a URL that shows all the needed code:

http://www.mvps.org/access/api/api0049.htm

RBS