Create word document from Excel File with Word Template
I was looking for help. I have an excel file which has cells of information which I would like to copy into a Word document which already exists and is essentially a template which I would like to copy information from the Excel document into the word template.
I have looked over the internet and found similar things but not what I am looking for.
Could someone help me with this and whether this can be done - I have attached the documents (word template and excel document) they will always reside in the same folder.
As a walk through I would like the macro (vba would be great) to do this.
Open the word template
copy the title from cell B2 in excel into the word document just after where it says Title on the first page
Copy the date from cell B3 into the word document in the cell next to where it says Date
Copy the range A1:D10 as a table into the space where it says <table to insert here> in the word document.
Copy the cell B6 from excel into the word document under where it says Header 1
Copy the cell B9 from excel into the word document under where it says Header 2 and then copy the cell B10 as a paragraph under the one copied just before.