If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Cannot empty the clipboard
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
Cannot empty the clipboard
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 "Cor" wrote: 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 |
#5
|
|||
|
|||
Cannot empty the clipboard
I meant rdpclip.exe
-- Bas V "Bas V" wrote: 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 "Cor" wrote: 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 |
#6
|
|||
|
|||
Cannot empty the clipboard
And if this .exe is NOT in the Processes list, THEN what? This clipboard
error is driving me NUTS! "Bas V" wrote: I meant rdpclip.exe -- Bas V "Bas V" wrote: 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 "Cor" wrote: 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 |
Thread Tools | |
Display Modes | |
|
|