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" wrote in message
...
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,

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" wrote in message
...
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" wrote in message
...
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,

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" wrote in message
...
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" wrote in message
...
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,

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" wrote in message
...
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" wrote in message
...
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,