If, in your user environment, there is the possibility that a use does not
have word
I would definitely use OnError to control the flow.
In our facility, Excel is always installed with Office, so if they have
Excel, they
have Word.

As for your copy/paste issue:
can you post your code?
I'll have to play with it a bit.
I've done it before, but I don't have the code with me now.

I've never used the " Application.ActivateMicrosoftApp (xlMicrosoftWord)"..
so i can't say on that.. every time i've had to communicate with word  i did it
using a vba procedure and created a word object. i can dig up some code for that
if you would like..

I found the answer on the web. Here is one way of Coping from Excel to Word in
case you need it later.

Step 5 was the key I was missing.