Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
excel copy cells to word template
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy excel cells to word without gridlines | Excel Discussion (Misc queries) | |||
excel copy cells to word template | New Users to Excel | |||
How can I have Excel cells populate a Word label template? | Excel Discussion (Misc queries) | |||
export/copy excel cells to Word | Excel Discussion (Misc queries) | |||
How do I copy cells from excel into word without the gridlines? | Excel Discussion (Misc queries) |