Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
clipboard in excel
I have a large piece of code involving copying and pasting LOTS of
data. I have application.cutcopymode = false after each paste line in my code. However I am viewing the clipboard in excel ina task pane and can see at the end of the code has 24 items in it. Is there another way to clear these items so I do not end up with huge amounts on the clipboard? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
clipboard in excel
Try this:
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() If OpenClipboard(0&) < 0 Then EmptyClipboard CloseClipboard End If End Sub Then when you want to clear the clipboard just do ClearClipboard RBS "keri" wrote in message oups.com... I have a large piece of code involving copying and pasting LOTS of data. I have application.cutcopymode = false after each paste line in my code. However I am viewing the clipboard in excel ina task pane and can see at the end of the code has 24 items in it. Is there another way to clear these items so I do not end up with huge amounts on the clipboard? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Where does Ms XL store the clipboard ? or where does MS Windowsstore clipboard ? | Setting up and Configuration of Excel | |||
Clipboard empty but still get waring that clipboard is full | Excel Discussion (Misc queries) | |||
Transfer clipboard from Task pane clipboard(office?) content to Excel (windows?) clipboard? | Excel Programming | |||
Restore clipboard from Task pane clipboard content? | Excel Programming | |||
ClearContents or ClearFormats also clears Clipboard. How can I keep the clipboard? | Excel Programming |