Your first link about the office clipboard looked good, but it didn't work
for me:
Application.CommandBars("Clipboard").Controls(4).E xecute
I found a comment on another forum that said you can't clear the office
clipboard with vba. I have tried recording a macro for clearing the
clipboard, but it just comes up blank. Instead I have settled for just
closing the clipboard:
Application.CommandBars("Task Pane").Visible=False
But since the Task Pane is only in newer versions of Excel, is that line of
code going to be an issue for users with an older version of Excel?
Thanks,
~ Horatio
"Héctor Miguel" wrote:
hi, Horatio !
I am using vba in one workbook to make changes in a target workbook.
I used application.cutcopymode=false to clear the clipboard, but it doesn't seem to work correctly.
I have the clipboard visible to the side of the window, and all of the copy/paste operations remain in the clipboard...
windows clipboard ?... see:
- http://www.cpearson.com/Excel/clipboard.htm
office clipboard ?... see:
- http://www.mvps.org/skp/off00004.htm#2
- http://support.microsoft.com/default...;en-us;q207438
- http://techsupt.winbatch.com/TS/T000001071F4.html
- http://support.microsoft.com/default...=kb;ES;A196620
hth,
hector.