#1   Report Post  
Posted to microsoft.public.excel.programming
MD MD is offline
external usenet poster
 
Posts: 7
Default Clipboard

his there a code to clear-up all that is stored in the office clipboard and
windows clipboard other than application.cutcopymode = false

thanks
Michel


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 691
Default Clipboard

Please don't repost the same question to another thread it makes
things difficult for everyone and wastes time. See J.E.'s answer
in http://google.com/groups?threadm=jem....microsoft.com

Not knowing anything about Macs, I would assume his
solution provided an answer to you and explained to the rest of
us why you don't want the obvious answer, and JE supplied a
reason why you might want something different.

Thanks for posting the original question with the detail of
not wanting the obvious answer -- that certainly saved one
round of back and forth conversation, but the reason would
have been good to include -- we can only guess if JE guessed right.

Please continue in your original thread.


  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default Clipboard

Public Declare Function OpenClipboard Lib "user32" ( _
ByVal hwnd AsLong) As Long
Public Declare Function CloseClipboard Lib "user32" () As Long
Public Declare Function EmptyClipboard Lib "user32" () As Long

Sub ClearClipboard()
OpenClipboard (0&)
EmptyClipboard
CloseClipboard
End Sub

Put declarations in a General module.

--
Regards,
Tom Ogilvy


MD wrote in message
...
his there a code to clear-up all that is stored in the office clipboard

and
windows clipboard other than application.cutcopymode = false

thanks
Michel




  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default Clipboard

Public Declare Function OpenClipboard Lib "user32" ( _
ByVal hwnd AsLong) As Long
Public Declare Function CloseClipboard Lib "user32" () As Long
Public Declare Function EmptyClipboard Lib "user32" () As Long

Sub ClearClipboard()
OpenClipboard (0&)
EmptyClipboard
CloseClipboard
End Sub

Put declarations in a General module.

--
Regards,
Tom Ogilvy

"MD" wrote in message
...
his there a code to clear-up all that is stored in the office clipboard

and
windows clipboard other than application.cutcopymode = false

thanks
Michel




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Clipboard traderduke Excel Discussion (Misc queries) 0 August 11th 09 04:50 PM
Where does Ms XL store the clipboard ? or where does MS Windowsstore clipboard ? Subu Setting up and Configuration of Excel 1 May 18th 09 06:56 AM
Where does Ms XL store the clipboard ? or where does MS Windowsstore clipboard ? Subu Setting up and Configuration of Excel 0 May 5th 09 01:20 PM
Clipboard empty but still get waring that clipboard is full Steve Excel Discussion (Misc queries) 0 June 17th 08 09:05 PM
Clipboard LACPA Excel Discussion (Misc queries) 5 June 24th 05 07:23 PM


All times are GMT +1. The time now is 05:18 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"