Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Clipboard Collisions
Message
 
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
00536525
Message ID:
00536579
Views:
8
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?
df (was a 10 time MVP)

df FoxPro website
FoxPro Wiki site online, editable knowledgebase
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform