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

VoG

Legend

Joined

Jun 19, 2002

Messages

63,650

• May 28, 2011

• #2

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

 

Upvote 0

F

Frith

Board Regular

Joined

Nov 1, 2009

Messages

99

• May 28, 2011

• #3

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

 

Upvote 0

VoG

Legend

Joined

Jun 19, 2002

Messages

63,650

• May 28, 2011

• #4

Try like this

Code:

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

 

Upvote 0

F

Frith

Board Regular

Joined

Nov 1, 2009

Messages

99

• May 28, 2011

• #5

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

 

Upvote 0

VoG

Legend

Joined

Jun 19, 2002

Messages

63,650

• May 28, 2011

• #6

Frith said:

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

Click to expand...

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).

 

Upvote 0