Cluttering Clip Board - Excel XP

[Hari Prasadh]

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/mi...clipboard+in+vb&rnum=1&hl=en#5f1dd61937ef0466
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

 

[Hari]

Hi,

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

Regards,
Hari
India

 

[NickHK]

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]

Hi Nick,

Thanks a lot for your rsponse. I tried editing the registry and re
running my macro but still facing the same problem.

Im resigned to this behaviour in Excel and presently I run this macro
in batches and combine the different word files at a later stage.

Regards,
Hari
India