This is not actually any clearer.

So that code is run from Word and will open a variable series of Excel files. When that happens, what data needs to move and in what direction?

I have a feeling that what you are trying to do is better done a different way. For instance, Rich Text CCs are not a good idea if you are expecting to move data between applications. I would be using Plain Text CCs to ensure the complexity is minimised.

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia