Why use the clipboard at all, especially since you are trying to do more than one at a time? The only thing I've ever seen recommended to use the clipboard for when automating Excel is for transferring a large amount of data because it's faster than setting each cell individually.
You can just directly manipulate all of the cell properties with automation calls.
>I have several FoxPro applications that are controlling Excel via OLE automation. They do a lot of copying and pasting of cell formats and such. All the copying and pasting causes a problem when 2 applications are running at the same time. It looks like they are fighting for the clipboard sometimes. One will copy to the clipboard, then before it can paste, another one copies over what was on the clipboard. Is there any way I can make them politely wait for their turn, or a way to use multiple clipboards?