Clearing Clipboard in Excel 2000

I want to clear clipboard in Excel 2000 using a shortcut
key not the mouse as I am creating a macro that will copy
and paste cells from a spreadsheet and manipulate them in
another program but the clipboard keeps getting full and
disrupting the execution of my macro with a dumb dialog
box telling me the clipboard is full. If this is not
possible, how do i disable the office clipboard in Excel
2000?

simplest way to deal with this is add-

application.displayalerts = false

before lines where unneccessary dialogue boxes are coming
up. make sure you add the same but with true at the end...

alternatively use application.cutcopymode= false after
performing pastes. This will clear the clipboard.


-----Original Message-----
I want to clear clipboard in Excel 2000 using a shortcut
key not the mouse as I am creating a macro that will copy
and paste cells from a spreadsheet and manipulate them in
another program but the clipboard keeps getting full and
disrupting the execution of my macro with a dumb dialog
box telling me the clipboard is full. If this is not
possible, how do i disable the office clipboard in Excel
2000?
.

Hi there,

I tried application.cutcopymode = false and that only
seems to clear the windows clipboard not the Office
clipboard that holds multiple items. The issue is that I
have a command in my macro that uses Ctrl V to paste what
should be on the clipboard. This does not paste the latest
addition to the office clipboard for some reason but the
one before it. Is there a way of turning off the Office
cliboard in Excel 2000?

Regards
Paula
-----Original Message-----
simplest way to deal with this is add-

application.displayalerts = false

before lines where unneccessary dialogue boxes are coming
up. make sure you add the same but with true at the end...

alternatively use application.cutcopymode= false after
performing pastes. This will clear the clipboard.


-----Original Message-----
I want to clear clipboard in Excel 2000 using a shortcut
key not the mouse as I am creating a macro that will
copy
and paste cells from a spreadsheet and manipulate them
in
another program but the clipboard keeps getting full and
disrupting the execution of my macro with a dumb dialog
box telling me the clipboard is full. If this is not
possible, how do i disable the office clipboard in Excel
2000?
.

.

I've turned off the office clipboard for me via:

Edit|Office Clipboard (to show it)
Then use the Options at the bottom of that clipboard toolbar.

wrote:

Hi there,

I tried application.cutcopymode = false and that only
seems to clear the windows clipboard not the Office
clipboard that holds multiple items. The issue is that I
have a command in my macro that uses Ctrl V to paste what
should be on the clipboard. This does not paste the latest
addition to the office clipboard for some reason but the
one before it. Is there a way of turning off the Office
cliboard in Excel 2000?

Regards
Paula
-----Original Message-----
simplest way to deal with this is add-

application.displayalerts = false

before lines where unneccessary dialogue boxes are coming
up. make sure you add the same but with true at the end...

alternatively use application.cutcopymode= false after
performing pastes. This will clear the clipboard.


-----Original Message-----
I want to clear clipboard in Excel 2000 using a shortcut
key not the mouse as I am creating a macro that will
copy
and paste cells from a spreadsheet and manipulate them
in
another program but the clipboard keeps getting full and
disrupting the execution of my macro with a dumb dialog
box telling me the clipboard is full. If this is not
possible, how do i disable the office clipboard in Excel
2000?
.

.


--

Dave Peterson

Hi Dave,

Are you using Office 2000? I don't seem to have any
options at the bottom of my clipboard toolbar.

Regards
Paula
-----Original Message-----
I've turned off the office clipboard for me via:

Edit|Office Clipboard (to show it)
Then use the Options at the bottom of that clipboard
toolbar.

wrote:

Hi there,

I tried application.cutcopymode = false and that only
seems to clear the windows clipboard not the Office
clipboard that holds multiple items. The issue is that
I
have a command in my macro that uses Ctrl V to paste
what
should be on the clipboard. This does not paste the
latest
addition to the office clipboard for some reason but the
one before it. Is there a way of turning off the Office
cliboard in Excel 2000?

Regards
Paula
-----Original Message-----
simplest way to deal with this is add-

application.displayalerts = false

before lines where unneccessary dialogue boxes are
coming
up. make sure you add the same but with true at the
end...

alternatively use application.cutcopymode= false after
performing pastes. This will clear the clipboard.


-----Original Message-----
I want to clear clipboard in Excel 2000 using a
shortcut
key not the mouse as I am creating a macro that will
copy
and paste cells from a spreadsheet and manipulate them
in
another program but the clipboard keeps getting full
and
disrupting the execution of my macro with a dumb
dialog
box telling me the clipboard is full. If this is not
possible, how do i disable the office clipboard in
Excel
2000?
.

.


--

Dave Peterson

.

Hi Pauls, l don't know if this will help but it works for me...
I think its one of Chips...

Public Sub ClearClipboard()
Dim MyDataObj As New DataObject
MyDataObj.SetText ""
MyDataObj.PutInClipboard
End Sub


hope this helps

seeya ste

No, I was using xl2002.

Sorry, I missed that 2000 in your post, subject, everything.



Paula wrote:

Hi Dave,

Are you using Office 2000? I don't seem to have any
options at the bottom of my clipboard toolbar.

Regards
Paula
-----Original Message-----
I've turned off the office clipboard for me via:

Edit|Office Clipboard (to show it)
Then use the Options at the bottom of that clipboard
toolbar.

wrote:

Hi there,

I tried application.cutcopymode = false and that only
seems to clear the windows clipboard not the Office
clipboard that holds multiple items. The issue is that
I
have a command in my macro that uses Ctrl V to paste
what
should be on the clipboard. This does not paste the
latest
addition to the office clipboard for some reason but the
one before it. Is there a way of turning off the Office
cliboard in Excel 2000?

Regards
Paula
-----Original Message-----
simplest way to deal with this is add-

application.displayalerts = false

before lines where unneccessary dialogue boxes are
coming
up. make sure you add the same but with true at the
end...

alternatively use application.cutcopymode= false after
performing pastes. This will clear the clipboard.


-----Original Message-----
I want to clear clipboard in Excel 2000 using a
shortcut
key not the mouse as I am creating a macro that will
copy
and paste cells from a spreadsheet and manipulate them
in
another program but the clipboard keeps getting full
and
disrupting the execution of my macro with a dumb
dialog
box telling me the clipboard is full. If this is not
possible, how do i disable the office clipboard in
Excel
2000?
.

.


--

Dave Peterson

.


--

Dave Peterson