I have a large workbook and I want to copy cells from one sheet called
Menu to a specific word template called PDC_MCC_IR.dot and save the
word template as a word document. I have a bit of code that can open a
word document and past information from cells in the word document but
I need help for the rest. Can anyone help me. Here is the code that I
already have.

Sub Excel_to_Word()
Dim appWord As Word.Application

Set appWord = New Word.Application

appWord.Visible = True

Range("b4:c10").Copy

appWord.Documents.Add.Content.Paste

Application.CutCopyMode = False



End Sub


Thanks Garry