Clear clipboard

[DMT Dave]

Hi Guy's i found this code on the internet, i am trying to clear clipboard in VBA, when i use DoCmd.RunCommand acCmdpaste

it is copying an earlier clipboard item

I admit, i do not understand this code but maybe is there a different method ?

Module

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

Private Sub

OpenClipboard (0&)
EmptyClipboard
CloseClipboard

[isladogs]

I use this code successfully in one of my apps. See http://www.mendipdatasystems.co.uk/s...ain/4594398120