View Single Post
  #2  
Old June 10th, 2007, 04:05 PM posted to microsoft.public.excel.misc
David McRitchie
external usenet poster
 
Posts: 606
Default Cannot empty the clipboard

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