excel copy and paste visual basic

so this is my first coding experience and im learning on the fly, so i dont have a real good background on VBA but i have written my macro to open up the themplate and place all the charts i need from the excel document into this word report we consistently use. My propblem comes where i need to insert the information from one cell into the word report in the middle of a paragraph. i can not get the macro to paste to word without inserting it as a cell, rather than the text that is inside the cell. any help would be greatly appreciated.

You can use this code:
to use the code (when open excel) choose Tools menu, then References and from the list select 'Microsoft Word xx.0 Object Library'

Please Login or Register  to view this content.

I hope it's what you need.

Regards,
Antonio