Wes,
Thanks for your reply. Actually I apologize for not being clear that I
am trying to clear the Office clipboard programmatically via VBA in an
Word AddIn Macro, not manually as a user. But if you know how to do
this, I'd be most grateful. I'm running Office Pro 2003. Thanks Wes!
-Greg
:
There are two different clipboards.
[[The Office Clipboard and the system Clipboard
The Office Clipboard is related to the system Clipboard in the
following ways:
When you copy multiple items to the Office Clipboard, the last item you
copy is always copied to the system Clipboard.
When you clear the Office Clipboard, the system Clipboard is also
cleared. When you use the Paste command, the Paste button, or the
shortcut keys (CTRL+V), you paste the contents of the system Clipboard,
not the Office Clipboard. ]]
Clear items from the Office Clipboard
1. If the Microsoft Office Clipboard is not displayed in the task
pane, click Office Clipboard on the Edit menu.
2. On the Office Clipboard task pane, do one of the following:
* To clear one item, click the arrow next to the item you want to
delete, and then click Delete.
* To clear all items, click Clear All .
--
Hope this helps. Let us know.
Wes
MS-MVP Windows Shell/User
In gregschottland <
[email protected]> hunted and
pecked:
Ken,
You mentioned this is no need to clear the clipboard, and I'd have
agreed with you, but running under Office 2k3, the clipboard is
configured to save many copy's of items which I like, when working in
Word. I've written a Word VBA AddIn that open a very large workbook,
worksheet at a time, then copy and paste them into Word as tables.
After a while, the clipboard consumes a lot of memory. So I'm
wondering is there any way for me to clear it out after each paste
(since I no longer need it and it eventually consumes too much
memory, causing problems for smaller memory boxes)? I have perused
the variety of answers as to how to do this, but nothing has proved
to actually clear the clipboard. Any ideas?
-Greg
:
raymond wrote:
After 'cutting', is there a way to clear the Clipboard other than
pasting? The question arose because I 'cut' something on a CD using
Windows Explorer. Of course, I couldn't paste it, because you can't
'cut' something this way from a CD, so I was stuck with something on
the Clipboard I couldn't paste. To clear the Clipboard, I 'cut'
something I could paste and pasted it. This is mildly onerous.
Is there a hot key or something like that you could use to clear the
Clipboard instead?
There's no way to clear the cflipboard, but there's also no *need* to
clear the clipboard. If you don't want to use what's currently in the
clipboard, just ignore it. The next time you cut or copy something to
it, it will replace what's there.