Clearing Clipboard in Excel 2000

[Paula]

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?

 

[Guest]

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.

 

[Guest]

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

 

[Dave Peterson]

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.

 

[Paula]

Hi Dave,

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

Regards
Paula

 

[ste mac]

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

 

[Dave Peterson]

No, I was using xl2002.

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