Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how do i empty the clipboard from within an excel macro
My macro opens a series of files (approx 32) and copies information from them
into the main file, closing the file with the information each time. The macro works OK, except each time it closes a file it requires manual intervention- asking if I want to empty the clipboard of the large amounts data stored in it. I would prefer that the macro automatically emptied the clipboard without the need for manual input. -any help please? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
how do i empty the clipboard from within an excel macro
application.cutcopymode = false
surreyjed wrote: My macro opens a series of files (approx 32) and copies information from them into the main file, closing the file with the information each time. The macro works OK, except each time it closes a file it requires manual intervention- asking if I want to empty the clipboard of the large amounts data stored in it. I would prefer that the macro automatically emptied the clipboard without the need for manual input. -any help please? -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
how do i empty the clipboard from within an excel macro
Here is a code snippet and the web site it came from. Dave's solution works
well in regular code where copy and paste actions have occurred. http://officeone.mvps.org/vba/clear_clipboard.html Sub ClearClipboard() CommandBars.FindControl(Id:=3634).Execute End Sub "surreyjed" wrote: My macro opens a series of files (approx 32) and copies information from them into the main file, closing the file with the information each time. The macro works OK, except each time it closes a file it requires manual intervention- asking if I want to empty the clipboard of the large amounts data stored in it. I would prefer that the macro automatically emptied the clipboard without the need for manual input. -any help please? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
how do i empty the clipboard from within an excel macro
That didn't work for me in xl2003.
What was it supposed to do? In this case, it sounds like the OP was describing the same situation that you described. JLGWhiz wrote: Here is a code snippet and the web site it came from. Dave's solution works well in regular code where copy and paste actions have occurred. http://officeone.mvps.org/vba/clear_clipboard.html Sub ClearClipboard() CommandBars.FindControl(Id:=3634).Execute End Sub "surreyjed" wrote: My macro opens a series of files (approx 32) and copies information from them into the main file, closing the file with the information each time. The macro works OK, except each time it closes a file it requires manual intervention- asking if I want to empty the clipboard of the large amounts data stored in it. I would prefer that the macro automatically emptied the clipboard without the need for manual input. -any help please? -- Dave Peterson |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
how do i empty the clipboard from within an excel macro
I didn't try it Dave. I saw it on the MVP web site and it said that the
snippet would clear the clipboard. Now I have tried it and I think something was leff out of the information on the web site. It asked for the object variable to be set. I'll look into it and find out what is missing. "Dave Peterson" wrote: That didn't work for me in xl2003. What was it supposed to do? In this case, it sounds like the OP was describing the same situation that you described. JLGWhiz wrote: Here is a code snippet and the web site it came from. Dave's solution works well in regular code where copy and paste actions have occurred. http://officeone.mvps.org/vba/clear_clipboard.html Sub ClearClipboard() CommandBars.FindControl(Id:=3634).Execute End Sub "surreyjed" wrote: My macro opens a series of files (approx 32) and copies information from them into the main file, closing the file with the information each time. The macro works OK, except each time it closes a file it requires manual intervention- asking if I want to empty the clipboard of the large amounts data stored in it. I would prefer that the macro automatically emptied the clipboard without the need for manual input. -any help please? -- Dave Peterson |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
how do i empty the clipboard from within an excel macro
I didn't try it in xl2007. Maybe it's a difference in versions????
JLGWhiz wrote: I didn't try it Dave. I saw it on the MVP web site and it said that the snippet would clear the clipboard. Now I have tried it and I think something was leff out of the information on the web site. It asked for the object variable to be set. I'll look into it and find out what is missing. "Dave Peterson" wrote: That didn't work for me in xl2003. What was it supposed to do? In this case, it sounds like the OP was describing the same situation that you described. JLGWhiz wrote: Here is a code snippet and the web site it came from. Dave's solution works well in regular code where copy and paste actions have occurred. http://officeone.mvps.org/vba/clear_clipboard.html Sub ClearClipboard() CommandBars.FindControl(Id:=3634).Execute End Sub "surreyjed" wrote: My macro opens a series of files (approx 32) and copies information from them into the main file, closing the file with the information each time. The macro works OK, except each time it closes a file it requires manual intervention- asking if I want to empty the clipboard of the large amounts data stored in it. I would prefer that the macro automatically emptied the clipboard without the need for manual input. -any help please? -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Clipboard empty but still get waring that clipboard is full | Excel Discussion (Misc queries) | |||
Clipboard empty but get cannot empty CB when trying to copy | Excel Worksheet Functions | |||
macro help - closing without saving & empty clipboard | Excel Discussion (Misc queries) | |||
Microsoft Excel can't empty the clipboard | Excel Discussion (Misc queries) | |||
empty clipboard using macro (vb script) | Excel Programming |