Cannot empty the clipboard

[Guest]

I use Excel VBA to create a standard e-mail (only contains plain text). This
text is linked within Excel.
Problem is that it has been working but now only an empty e-mail is the
result. No body text only the header.
When checking the clipboard it appears that nothing is copied into it. Never
min using CTRL+C/CTR+V or via the menu !
When checking the clipboard nothing is there and still I get message "cannot
empty clipboard"

Pls advice

Cor Verheul

 

[David McRitchie]

see if last macro fixes the problem at all, and if
it recurs or not.
http://www.cpearson.com/excel/clipboard.htm

If not familiar with installing macros see
http://www.mvps.org/dmcritchie/excel/getstarted.htm#havemacro
paste the entire code 3 declaration then the sub... end sub
after option explicit in a new module.

If still a problem indicate your version of Excel and your operating
system and version and Service Pack level.

 

[Guest]

I am stuck in break mode. Your instructions say to "fix your macro errors
and then press therun button to continue". How do I fix my macro? This is
the macro I copied from your link.

Declare Function CloseClipboard Lib "user32" () As Long
Declare Function EmptyClipboard Lib "user32" () As Long
Declare Function OpenClipboard Lib "user32" (ByVal hwnd As Long) As Long

Sub ClearClipboard()
OpenClipboard 0&
EmptyClipboard
CloseClipboard
End Sub

 

[Bas V]

Goeie middag!

I have problems also with this message in Excel 2007.
Use taskmanager to end process called rdclip.exe.
That may help you.

 

[Bas V]

I meant rdpclip.exe
--
Bas V

Goeie middag!

I have problems also with this message in Excel 2007.
Use taskmanager to end process called rdclip.exe.
That may help you.

 

[USAOz]

And if this .exe is NOT in the Processes list, THEN what? This clipboard
error is driving me NUTS!