When I compile the code below (in Access 2003) I get an error at this line :

'OpenClipboard Application.hwnd' (hwnd is highlighted)

The error I get is "method or data member not found"

What is causing this ????????


"RB Smissaert" wrote:

Click to show or hide original message or reply text.


> Sorry, that should be:
>
> Option Explicit
> Private Declare Function OpenClipboard Lib "user32" (ByVal hwnd As Long) As
> Long
> Private Declare Function CloseClipboard Lib "user32" () As Long
> Private Declare Function EmptyClipboard Lib "user32" () As Long
>
> Sub ClearClipboard()
> OpenClipboard Application.hwnd
> EmptyClipboard
> CloseClipboard
> End Sub
>
> The clipboard has to be opened first and then closed after clearing it.
>
> RBS
>
>
>
> "Reuel" <[email protected]> wrote in message
> news:[email protected]...
> > Is there any way to clear the clipboard in a macro run? I've been having
> > strange programmatic freezes after a long series of cut/paste/select
> > operations (see previous post by me) and I thought that it might help
> > force a
> > clear of the clipboard periodically.
> >
> > Also, can anyone suggest another resource for help when no one inthis
> > forum
> > has a suggestion for solving Excel programming problems?
> > Thanks,
> >
>
>