Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy & Paste - Unsafe?
Hi, I'm hoping that an MVP can help settle a dispute (and save me some
reprogramming). I have written a consolidation routine that takes data from a number of formatted workbooks and consolidates it into a single 'Master_Data' sheet. As the code loops through each source workbook it defines the area to be copied then copies and pastes it to the Master_Data sheet using the following 2 lines of code... rngAllocation.Copy rngMaster.PasteSpecial Paste:=xlPasteValues, _ Operation:=xlNone, SkipBlanks:=False, Transpose:=False During a code review, a colleague pointed out that this was unsafe because another Excel application could be running at the same time on the dual processor server and use the Windows paste buffer between my code's copy and paste buffer operations, causing my code to paste the wrong information. I've never heard of this happening. Is there a slight risk? Best regards, Nick H |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
potentially unsafe attachment | Excel Discussion (Misc queries) | |||
Cut is unsafe - call for solutions | Excel Programming | |||
Excel cut/Paste Problem: Year changes after data is copy and paste | Excel Discussion (Misc queries) | |||
This application is about to initialize controls that might be unsafe. ... | Excel Programming | |||
Unsafe ActiveX Controls Issue | Excel Programming |