It looks like the code will always be dependent on the version of excel being
used.
I found a different solution, though. There are samples for bypassing the
clipboard, instead of using Copy/Paste, at
http://www.ozgrid.com/VBA/SpeedingUpVBACode.htm
I have tried it out, and it works great.

Thanks for the help.
~ Horatio


"Héctor Miguel" wrote:

hi, Horatio !

Your first link about the office clipboard looked good, but it didn't work for me:
Application.CommandBars("Clipboard").Controls(4).E xecute

office clipboard for xl2000, try with:
- Application.CommandBars.FindControl(ID:=3634).Exec ute

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?

office clipboard "moved" to task-pane (xl2002 / xl2003) and AFAIK...
- it does not expose its OM to VBA :-((
- closest approach ?... see Michael Pierrone (post # 6) in: - http://tinyurl.com/2j8y4x

hth,
hector.