View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default Cluttering Clip Board - Excel XP

Hari,
For what its worth, I disabled the Office Clipboard years ago and never seem
to have these kinds of problems, although I may not copy/paste as much as
you.

http://techsupt.winbatch.com/TS/T000001071F4.html

NickHK

"Hari" wrote in message
oups.com...
Hi,

Would somebody please suggest a way to overcome the clipboard problem.

Regards,
Hari
India

Hari Prasadh wrote:
Hi,

Iam copying lots and lots of data (tables) from excel and pasting to

word
using automation and For Loops.

My computer (XP home, Office 2002, 1.8 GHz and 1 GB RAM) slows down
terribly and some time just hangs up because of huge amount of

repetitive
copy-paste. I have tried in computers of differing configurations but

havent
had any luck.

I have tried clearing clipboard using Chip P's suggestions in the link

http://groups.google.co.in/group/mic...1dd61937ef0466
but none of the mentioned method works for me. I dont get any error,

but
while executing the code in F8 I see that my clipboard still shows the

same
amount of available items for pasting as before executing the clip-board
clear code . (I did set references to Microsoft forms 2.0 library).

Could anybody tell me what am doing incorrectly?

(The code for copy pasting to word is a fairly standard one).

Thanks a lot,
Hari
India