View Single Post
  #3  
Old June 26th, 2007, 04:49 PM posted to microsoft.public.excel.misc
Kathryn Pundt[_2_]
external usenet poster
 
Posts: 39
Default Cannot empty the clipboard

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

"David McRitchie" wrote:

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....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.
--
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Cor" wrote in message ...
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