Excel to Word

  • Thread starter Thread starter Raz
  • Start date Start date
R

Raz

Is it possible to link from word to excel???
I have a table in Word, would like to fill some of its cell from an Excel
Workbook.
Possible??
How would I do that??

thanks in advance.
 
Here is one option:
http://www.erlandsendata.no/english/index.php?d=envbaolecontrolword

Take a look at this:
http://word.mvps.org/FAQs/InterDev/ControlWordFromXL.htm

This too:
http://addbalance.com/usersguide/fields.htm

And this:
http://gregmaxey.mvps.org/Word_Fields.htm

Finally, once you get the DocVariable fields set up in Word (hit Alt + F9 to
see all fields), run this code from Excel.
Sub PushToWord()

Dim objWord As New Word.Application
Dim doc As Word.Document
Dim bkmk As Word.Bookmark
sWdFileName = Application.GetOpenFilename(, , , , False)
Set doc = objWord.Documents.Open(sWdFileName)

With doc
..Variables("VarNumber1").Value = Range("VarNumber1").Value
..Variables("VarNumber2").Value = Range("VarNumber2").Value
'etc
..Range.Fields.Update
End With

'ActiveDocument.Fields.Update

objWord.Visible = True

End Sub

Note: This code runs in Excel; pushes Excel variables (assigned as Named
Ranges) to Word. Make sure you set a Reference to Word, under Tools >
References.

Let me know if you have any questions.
 
Hi Raz,

Copy the Excel data, then, in Word:
1. select the insertion point
2. go to Edit|Paste Special, choose 'paste link' and a paste format; and
3. press OK.
To paste into a range of cells in an existing Word table, you'll need to copy/paste the Excel data for each cell separately.
 
Back
Top