Clearing "Microsoft Office" clipboard

[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 (using CTRL C & CTRL V) from a spreadsheet
and manipulate them in another program but the "office"
clipboard keeps getting full and disrupting the execution
of my macro with a dumb dialog box telling me the
clipboard is full. (also the CTRL V does not paste the
latest copied item in the clipboard only the first).
Basically my question is, "How do i disable the "Microsoft
office" clipboard (that holds multiple items) in Excel
2000?"

Regards

p.s. I have tried the:
application cutcopymode = false
and
application.displayalerts = false

but they are not solving the problem

 

[Frank Stone]

Try Application.CutCopyMode = False
(add a dot)

 

[ste mac]

Hi Paula..

I want to clear clipboard in Excel 2000

This is the code I use to empty the clipboard.. i think its one of Chip's

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

It definately works for me...

seeya ste

 

[Paula]

Hi there,

I tried the below code but I keep getting a compile
error "User-defined type not defined" error message and
the highlight is on the "MyDataObj As New DataObject".
Can anyone help me with this??

Paula

 

[ste mac]

Oops.. just sent the same code to your other post (thought you may not
have seen it) please disregard...

seeya ste

 

[Dave Peterson]

You'll need a reference to Microsoft Forms 2.0 Object Library.

Inside the VBE, tools|references, and select that reference.