I saw a work-around on another list -- depending on how you define "empty",
you could just do a loop and paste a series of null strings to the
clipboard. That would "push off" everything in the clipboard...
On Wed, Nov 23, 2011 at 12:43 PM, sspatriots <sspatriots@yahoo.com> wrote:
> I've found numerous post with code that is supposed to empty the clipboard
> contents from the following:
>
> 1. Clear the Office Clip Board.
> 2. Clear the Windows Clip Board
> 3. Clear the last Cut/Copy/Paste cell tag.
>
> Everyone I have tried will not work in Excel 2010 or it may be just how
> I'm trying to make it work. Either way, my clipboard never gets cleared
> unless I close everything and get back in. Any ideas on what works best and
> how to make it work?
>
[Non-text portions of this message have been removed]
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.
----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com
----------------------------------
Tidak ada komentar:
Posting Komentar