Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data to a specific location into a word document
I got this code from Ed (thanks), and I was wondering if there was a way to
possible to get this information into a specific location in a document. I have this existing template and there is this area for these paragraphs, so I need to see if it can go in that area. Set a range to encompass all the rows with data Set objects to Word and a new document With DataRange For i = 1 to DataRange.Rows.Count String1 = "ID: " & .Cells(i,1).Value & ", " WordDoc.Selection.TypeText String1 & vbCr String2 = "Description: " & .Cells(i, 2).Value & ", " WordDoc.Selection.TypeText String2 & vbCr etc. to last cell Next i Save and close Word doc; quit Word, release objects Save and close Excel file Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
hyperlinking to a specific page of a word document | Excel Discussion (Misc queries) | |||
How to hyperlink to a specific location in a Word document? | Excel Discussion (Misc queries) | |||
getting specific info from a word document into excel | Excel Discussion (Misc queries) | |||
Getting specific data from a word document into an excel sheet | Excel Worksheet Functions | |||
Opening Word with a specific document from excel vba | Excel Programming |