Cluttering Clip Board - Excel XP

H

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
 
H

Hari

Hi,

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

Regards,
Hari
India
 
H

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
 
Top