Any Code for Clearing the Clipboard After Paste...?

[Frith]

Hi all,

Anyone know if, in Excel (or in Windows in general, for that matter), there's a way to dump the clipboard AFTER AN INITIAL paste (like a "paste once" only kinda thing)? Say, I copy the word "cool" from some non-office App, then paste it in a WS. After pasting this, I need an empty clipboard... Do I ask the impossible?

Thanx,
Frith

 

[VoG]

See Empty Clipboard http://www.cpearson.com/excel/clipboard.aspx

 

[Frith]

Hi again,


On that site, it says:

"Within Excel, you can clear Excel data from the clipboard with: Application.CutCopyMode = False."

So... now I do exactly "what" with this command? And if I do, will it still allow me to paste data "ONCE" before clearing the clipboard?


Thanx again
Frith

 

[VoG]

Try like this

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


Sub pst()
ActiveSheet.Paste
Call ClearClipboard
End Sub


Sub ClearClipboard()
    OpenClipboard (0&)
    EmptyClipboard
    CloseClipboard
End Sub

 

[Frith]

Nah, I'm still able to paste the same data multiple times in multiple cells, instead of just once... No worries, though. I guess I can live with it.

Thanx

 

[VoG]

Nah, I'm still able to paste the same data multiple times in multiple cells, instead of just once

I can't. If I copy from notepad then run the Pst macro it pastes. If I run pst again it errors (because the clipboard is empty).