| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to copy/paste without using clipboard?
Hmm, Forget that, it does use the clipboard. "Mike H" wrote: Hi, Apart from saying there is a problem in using the clipboard you never quite got around to telling us what that problem is. Anyway, this doesn't use the clipboard Sheet2.Range("A1:a100").copy Sheet1.Range("B1") Mike "Ming" wrote: I'm using Excel to generate some reports in background which could take long time. The problem is that a lot of copy/paste is used in the template for generating those reports which makes the Window clipboard unusable for the user working in foreground. There are two ways you can copy/paste data around in Excel. One is Selection.Copy and ActiveSheet.Paste. It copies the content in Windows clipboard which can be shared by other applications. I can understand why this function uses clipboard. There second way is to use Range.Copy [Destination] to copy and paste in one function call. This function also uses clipboard. Actually, it copies into clipboard and clears it right away. So, the content can't be shared at all. Therefore, there is really no reason to use the clipboard. Sadly, this is the way it behaves. There is another similar function Worksheet.Copy [Destination] which doesn't use clipboard. Anybody is aware of workaround for this problem? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy and paste not functioning, think clipboard problem | Excel Worksheet Functions | |||
| clipboard copy & paste | Excel Discussion (Misc queries) | |||
| WHY IS THE OFFICE CLIPBOARD NOT LETTING ME COPY AND PASTE? | Excel Discussion (Misc queries) | |||
| Copy / Paste Function & the Office Clipboard | Excel Discussion (Misc queries) | |||
| Copy / Paste Function & the Office Clipboard | Excel Discussion (Misc queries) | |||
Threaded Mode
