VBA copy paste into word

[klutch]

Hello all, I am working on a new project and have no experience with VBA but I understand the concepts of it.
I am trying to copy/paste a singular cell into a word template, I am struggling to find the code to pull up the correct file, as well as not being able to properly copy the range and paste it.
Does anyone have some standard code for this I could use?

 

[klutch]

For clarification, I have data for specific products from a 3rd party software that is exporting data into excel for me. I am working to export this data (one cell) into a word document template that is specific to each product (file name is identical to product#) using macro. Is there a way to code excel so that the data will copy/paste into the specific file for that data? I am also trying to put the data into a specific location within the word doc.
Cell is J2
File path is Libraries\Documents and file name is Template.doc
<div class="postfoot"><!-- -->