Clipboard Clear API error

[G-Force]

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.


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,
> >
>
>

[Greg Wilson]

This works for me in Excel. I never use Access:
OpenClipboard (0&)

I believe Application.Hwnd is only recognized in VB as opposed to VBA.

Regards,
Greg


"G-Force" wrote:

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

[Chip Pearson]

The Access object model does not expose the HWnd property of the
Application object. You can pass 0 to OpenClipboard instead of
the HWnd.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"G-Force" <[email protected]> wrote in message
news:[email protected]...
> 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.
>
>
> 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,
>> >
>>
>>
>

[G-Force]

Thanks Greg. I'll try this.

"Greg Wilson" wrote:

> This works for me in Excel. I never use Access:
> OpenClipboard (0&)
>
> I believe Application.Hwnd is only recognized in VB as opposed to VBA.
>
> Regards,
> Greg
>
>
> "G-Force" wrote:
>
> > 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.
> >
> >
> > 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,
> > > >
> > >
> > >
> >

[G-Force]

Thanks Chip - I'll try passing 0 with a % sign. gr

"Chip Pearson" wrote:

> The Access object model does not expose the HWnd property of the
> Application object. You can pass 0 to OpenClipboard instead of
> the HWnd.
>
>
> --
> Cordially,
> Chip Pearson
> Microsoft MVP - Excel
> Pearson Software Consulting, LLC
> www.cpearson.com
>
>
> "G-Force" <[email protected]> wrote in message
> news:[email protected]...
> > 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.
> >
> >
> > 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,
> >> >
> >>
> >>
> >
>
>
>

[G-Force]

Actually i'll use 0 with a Ampersand - Thanks. GR

"Chip Pearson" wrote:

> The Access object model does not expose the HWnd property of the
> Application object. You can pass 0 to OpenClipboard instead of
> the HWnd.
>
>
> --
> Cordially,
> Chip Pearson
> Microsoft MVP - Excel
> Pearson Software Consulting, LLC
> www.cpearson.com
>
>
> "G-Force" <[email protected]> wrote in message
> news:[email protected]...
> > 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.
> >
> >
> > 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,
> >> >
> >>
> >>
> >
>
>
>