Cluttering Clip Board - Excel XP
 

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

Cluttering Clip Board - Excel XP
 

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

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

Cluttering Clip Board - Excel XP
 

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

NickHK wrote:
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