Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.newusers
|
|||
|
|||
How to import data from Excel into a Word doc
I'm sure there's a simple solution, but I cannot find out how to do the
following. I am populating different fields in a Word doc and would like to pull the data from specific cells in an Excel file. I do this many times using the same Word and Excel template, so I would also like to be able to change the "source" Excel file as you can when pulling data from one Excel file to another. By the way I am running Office 2007 and Vista. Thanks in advance for your help!! Shawn |
#2
Posted to microsoft.public.word.newusers
|
|||
|
|||
How to import data from Excel into a Word doc
The following macro will probably do what you require.
' Macro created 26/10/01 by Doug Robbins to update links in a document ' Dim alink As Field, linktype As Range, linkfile As Range Dim linklocation As Range, i As Integer, j As Integer, linkcode As Range Dim Message, Title, Default, Newfile Dim counter As Integer counter = 0 For Each alink In ActiveDocument.Fields If alink.Type = wdFieldLink Then Set linkcode = alink.Code i = InStr(linkcode, Chr(34)) Set linktype = alink.Code linktype.End = linktype.Start + i j = InStr(Mid(linkcode, i + 1), Chr(34)) Set linklocation = alink.Code linklocation.Start = linklocation.Start + i + j - 1 If counter = 0 Then Set linkfile = alink.Code linkfile.End = linkfile.Start + i + j - 1 linkfile.Start = linkfile.Start + i Message = "Enter the modified path and filename following this Format " & linkfile Title = "Update Link" Default = linkfile Newfile = InputBox(Message, Title, Default) End If linkcode.Text = linktype & Newfile & linklocation counter = counter + 1 End If Next alink -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Shawn" wrote in message ... I'm sure there's a simple solution, but I cannot find out how to do the following. I am populating different fields in a Word doc and would like to pull the data from specific cells in an Excel file. I do this many times using the same Word and Excel template, so I would also like to be able to change the "source" Excel file as you can when pulling data from one Excel file to another. By the way I am running Office 2007 and Vista. Thanks in advance for your help!! Shawn |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Import data from Excel to Word | Microsoft Word Help | |||
Using Mail Merge to import Excel data to Word for printing checks | Mailmerge | |||
Import data from Excel into a two column page in word | Microsoft Word Help | |||
Import Excel data into word as text | Microsoft Word Help | |||
import data into word from excel or access | Microsoft Word Help |