Home |
Search |
Today's Posts |
#1
|
|||
|
|||
word and excel
Is there an easy way to have a word file let the user select a field from an excel file (like a drop down box) and then have other data related to that field update in the word file? I assume I have to do this with a macro but I thought it may be worth asking first. |
#2
|
|||
|
|||
The following doesn't deal with the Excel-Word part but may give you an idea
' Macro2 Macro ' Macro created 15-11-97 by Doug Robbins to add the address corresponding to a drop down name ' Set myDrop = ActiveDocument.FormFields("Dropdown1").DropDown Company = myDrop.ListEntries(myDrop.Value).Name Address = ActiveDocument.AttachedTemplate.AutoTextEntries(Co mpany).Value ActiveDocument.FormFields("Text1").Result = Address -- 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 "Joe" wrote in message ... Is there an easy way to have a word file let the user select a field from an excel file (like a drop down box) and then have other data related to that field update in the word file? I assume I have to do this with a macro but I thought it may be worth asking first. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Difficulty pasting Excel data into Word table only in XP versions | Tables | |||
How do I create & merge specific data base & master documents? | New Users | |||
Excel worksheet in Word linked text boxes | Page Layout | |||
Word Field Codes in Excel data file | Mailmerge | |||
formatting links from excel into word (extra line feeds) | Microsoft Word Help |