Clip Board Properties

steve case · Apr 11th, 2002, 06:26 PM

If text is copied from Notepad, it stays on the clip board even through operations that delete cell contents. If a cell or range of cells is copied, it disappears from the clip board as soon as information is entered into any cell or any cell's contents are cleared.

Can this difference be controlled? If so How?

Mark O'Brien · Apr 11th, 2002, 06:31 PM

That's a very good question and I'd like to know the answer as well.

The one thing I can tell you is that I don't think that cells get copied to the clipboard at all, or else they would be available afterwards as you state.

I hope someone answers this one because I'm in too lazy a mood to try to find out as well.

Ivan F Moala · Apr 12th, 2002, 02:10 AM

Have a look @ http://support.microsoft.com/default...;EN-US;q221190

steve case · Apr 12th, 2002, 06:16 AM

From Ivan's source above:

"There is no Visual Basic for Applications object model for the Office Clipboard, so there is no way to programmatically manipulate it."

I'm a novice, and for me that's the end of the story. But I'll stay tuned

Ivan F Moala · Apr 12th, 2002, 06:21 AM

Quote:

On 2002-04-12 05:16, StACase wrote:
From Ivan's source above:

"There is no Visual Basic for Applications object model for the Office Clipboard, so there is no way to programmatically manipulate it."

I'm a novice, and for me that's the end of the story. But I'll stay tuned

Is there something specific you wanted to do
with the clipboard ??

Mark O'Brien · Apr 12th, 2002, 06:57 AM

Quote:

On 2002-04-12 01:10, Ivan F Moala wrote:
Have a look @ http://support.microsoft.com/default...;EN-US;q221190

Thanks Ivan

I couldn't find that in the knowledge base.

steve case · Apr 12th, 2002, 10:33 AM

Ivan asked:

"Is there something specific you wanted to do
with the clipboard ?? "

The other day, I wanted to know if something was on it, and you graciously supplied the error message box code - whiched worked right out of the box. Thanks again

! But what I thought I wanted to do was detect if there was anything on the clip board, and then I was going to create my own error message. Like I said, I'm a novice to this. Now I'm just curious, but I know that knowing how to access the status of the clip board will come in handy. So, No, I don't have anything specific. Well not any more

Apr 12th, 2002, 02:10 AM	#3
Ivan F Moala MrExcel MVP Join Date: Feb 2002 Location: Auckland, New Zealand Posts: 4,209	Have a look @ http://support.microsoft.com/default...;EN-US;q221190 __________________ Kind Regards, Ivan F Moala From the City of Sails

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 11th, 2002, 06:26 PM	#1
steve case Board Regular Join Date: Apr 2002 Posts: 682	If text is copied from Notepad, it stays on the clip board even through operations that delete cell contents. If a cell or range of cells is copied, it disappears from the clip board as soon as information is entered into any cell or any cell's contents are cleared. Can this difference be controlled? If so How?

Apr 11th, 2002, 06:31 PM	#2
Mark O'Brien MrExcel MVP Join Date: Feb 2002 Location: Columbus, OH, USA Posts: 3,519	That's a very good question and I'd like to know the answer as well. The one thing I can tell you is that I don't think that cells get copied to the clipboard at all, or else they would be available afterwards as you state. I hope someone answers this one because I'm in too lazy a mood to try to find out as well.

Apr 12th, 2002, 06:16 AM	#4
steve case Board Regular Join Date: Apr 2002 Posts: 682	From Ivan's source above: "There is no Visual Basic for Applications object model for the Office Clipboard, so there is no way to programmatically manipulate it." I'm a novice, and for me that's the end of the story. But I'll stay tuned

Apr 12th, 2002, 10:33 AM	#7
steve case Board Regular Join Date: Apr 2002 Posts: 682	Ivan asked: "Is there something specific you wanted to do with the clipboard ?? " The other day, I wanted to know if something was on it, and you graciously supplied the error message box code - whiched worked right out of the box. Thanks again ! But what I thought I wanted to do was detect if there was anything on the clip board, and then I was going to create my own error message. Like I said, I'm a novice to this. Now I'm just curious, but I know that knowing how to access the status of the clip board will come in handy. So, No, I don't have anything specific. Well not any more