Clipboard clear

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

OpenClipboard Application.hwnd

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

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


"RB Smissaert" wrote:

> 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" <Reuel@discussions.microsoft.com> wrote in message
> news:C6DA21DE-9995-4F27-B576-D52A15FF3BF4@microsoft.com...
> > 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,
> >
>
>

Try 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
Public Function ClearClipboard()
OpenClipboard (0&)
EmptyClipboard
CloseClipboard
End Function


HTH

--
Regards,
Zack Barresse, aka firefytr, (GT = TFS FF Zack)



"G-Force" <GForce@discussions.microsoft.com> wrote in message
news:828C4187-BB0B-461F-A054-772F4D2F1C86@microsoft.com...
> When I compile the code below (in Access 2003) I get an error at this line
> :
>
> OpenClipboard Application.hwnd
>
> The error I get is "method or data member not found"
>
> What is causing this ????????
>
>
> "RB Smissaert" wrote:
>
>> 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" <Reuel@discussions.microsoft.com> wrote in message
>> news:C6DA21DE-9995-4F27-B576-D52A15FF3BF4@microsoft.com...
>> > 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,
>> >
>>
>>