Protect clipboard data from other programs trying to use clipboard at same time?

Thanks much for your responses.

I'll try the 2 methods you both suggested. It looks like using the word "copy" anywhere then uses the clipboard. Also on using "resize" does both source and destination need known exact sizes?

It is sounding like there is no way to protect the clipboard data, as it is open season for any application to use at any time? Am I assuming correctly on that?

I'm with teylyn here.

Besides, a PM seems to me to be the appropriate method to distribute personal comments. Personal comments in a thread do not contribute to the solution of the TS's question.

Nobody is asking about your love life, just a bit more help in understanding your outstanding code.
Just ask yourself this "How long did I take to be as clever as this?" Then think of others.

Another good example here.Post #7
http://www.excelforum.com/excel-prog...-and-name.html

I am not sure, but unfortunately it looks like there is no way to protect data copied into the clipboard, if an other program copies their data into the clipboard before you paste what you copied there.

Unless someone knows of a way to stop other programs from corrupting the clipboard before you use it to paste, I likely will have to rewrite all my copy routines so the clipboard is not used during any copying.

From reading the "very helpful posts here" this is the code I have come up with that will:

Copy cell data between worksheets (even inactive sheets) "without using the clipboard". Uses row and column cells format.

Please Login or Register  to view this content.

The above line of code used to copy data "without" using the clipboard:

Please Login or Register  to view this content.

has a "with" version that also seems to work the same which is:

Please Login or Register  to view this content.

Is one of these versions of code faster or more efficient than the other?

That kind of looks like a structure from my 'C' programming days (I am new to programming again).

Could you give an example on how you would then "referenced in subsequent statements with just the dot" from your with example?

Thanks.

I am assuming that you declared a new "myRange" having those following properties?

So to change Bob's name to Ted, a next statement could be:

Please Login or Register  to view this content.

Is that correct?

So inside the same function I could just change Bob's name to Ted by later using a single line of code:

Please Login or Register  to view this content.

In same function, if I have 2 different "With" statements that both have a property of .value, would I then have to use the myRange to clarify which With I would be referring to for .value?

I can see how the nested With's work. Very useful tight code.

I am assuming that the .copy would be using the clipboard.

Just a note of caution when you are using the With ... End With construct. If, for example, you are using it with ranges within sheets, this:

Please Login or Register  to view this content.

Is not the same as:

Please Login or Register  to view this content.

although, if Sheet1 is the active sheet, the result will be the same.

If, however, Sheet1 is not the Active Sheet, the result will be unpredicatable.

It can be a pig to debug because you tend to look at the sheet where the data is coming from, thus making it the Active Sheet. So, when you step through, it works; when you run it normally, it can fail.

I may be particularly stupid, but I've spent many unhappy hours trying to work through issues that are caused by a missing dot!

That's not to negate the benefits ... just be careful out there.

Regards

Just a little 'ole dot. I was just reading that using "Worksheets" will make inactive sheets valid. Such as using your example:

Please Login or Register  to view this content.

changed to:

Please Login or Register  to view this content.

is supposed to make inactive sheets valid. Perhaps a missing dot might still be trouble there too?

I am still working on trying to make the .copy not use the clipboard. I am nesting an other with being set to the 2nd col but not quite there yet.

Lot of info there for me to study. Due to time pressures I think I will for now use code without the nested "With's" as my understanding not quite all there yet.

Following code should work to copy "without" using the clipboard:

Please Login or Register  to view this content.

It copies the values ok, but how would I get it to also copy the cell colors too?

Thanks.

It looks like the CTRL-C and CTL-V copy and paste which uses the clipboard moves most everything. But it of course uses the clipboard which causes my programs running at same time to interfere with each other when clipboard gets corrupted when simultaneous use happens.

Using the very helpful examples and suggestions here, I ended up learning that the other ways NOT using the clipboard takes a bit more coding to transfer other things besides just the value over. I preformatted the target cells for colors and such before I could then just transfer the values.

It works great and I tried to crash the programs using the clipboard and no problems now.

I thank everyone for their suggestions and help!

Chuck

Solved this problem by going at it from a different angle. Jaafar on an other forum wrote some code to protect the clipboard from use by other programs. And then also has some code for other programs to use in their macros to wait until the clipboard is freed up (unprotected) before they try to also use it themselves which would cause an error not being able to copy and likely crash or stop any macro at that point.

All that got solved with the discussion and code here:

http://www.mrexcel.com/forum/showthread.php?t=495746

Thanks for all the help here too, as I used some of the suggestions here too when I did not wish to use the clipboard to copy.

Chuck