Yep. It's the Office clipboard that I want to dump. I can do it manually by making the Office Clipboard Task Pane visible then selecting "Clear All", but I was hoping to accomplish this in my code some how. Thanks.
--- In ExcelVBA@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> I Googled a bit and found this solution, which appears to work here:
>
> Option Explicit
> Public Declare Function OpenClipboard Lib "user32" (ByVal hwnd As Long) As
> Long
> Public Declare Function EmptyClipboard Lib "user32" () As Long
> Public Declare Function CloseClipboard Lib "user32" () As Long
>
> Public Sub ClearClipboard()
> OpenClipboard (0&)
> EmptyClipboard
> CloseClipboard
> End Sub
>
> But I'm not talking about the Office Clipboard -- just the currently held
> clipping that's ready for pasting.
>
> On Wed, Nov 23, 2011 at 12:43 PM, sspatriots <sspatriots@...> 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