Excel VBA: copy Excel and paste into Word as text

I've been working on this for about a week and I'm thoroughly frustrated. I have tried this a bunch of ways, so I'm assuming there is something else wrong with the code. I'm also doing this without a reference to the MSWord Object Library, as I need this to work for any version of Office. Can someone take a look?

I'm trying to copy a range from the current excel sheet (this part works great) and then open word and paste into a new document as text.

The error I keep getting is a run time "error 424: Object needed." on the line that begins .Selection

Please Login or Register  to view this content.

Thanks!

Originally Posted by pjwhitfield

Right, I dont understand why this makes a difference as its not sensible but the following works.

Please Login or Register  to view this content.

Oddly, that does work but it doesn't paste as text, it's just a regular paste.

I think I figured it out

I changed

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

where 22 is the const for "wdFormatPlainText"