Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
How to link a word and excel documents
I have a word document that I turned into a "packing slip" for our company,
is there a way to have the address section of the document reference an excel document so information can be pulled from it? I am looking for if they start typing in the company name in that address field (on the word document) it will fill it in. |
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
How to link a word and excel documents
Hi ?B?eWVmaXdzYm9y?=,
I have a word document that I turned into a "packing slip" for our company, is there a way to have the address section of the document reference an excel document so information can be pulled from it? I am looking for if they start typing in the company name in that address field (on the word document) it will fill it in. Nothing simple, or built-in. You could certainly do something using a macro. Best place to pursue that would be the word.vba.general newsgroup. BE sure to provide the following information: 1. Whether you have any VBA experience, and in what application 2. Version of Office involved 3. (Sample) file path and name, as well as the name of the column with the information FWIW, the "best" approach is probably going to be displaying a Form where the user can type / select information that will later be inserted into the document. Unless you're using form fields? Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005) http://www.word.mvps.org This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail :-) |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I link Word to Excel...?? | Microsoft Word Help | |||
link word data and excel | Microsoft Word Help | |||
2 Excel Workshts in Word - Can you link them? | Microsoft Word Help | |||
If you add 2 excel workshts in a word doc. is it possible to link | Microsoft Word Help | |||
Excel Link: Adding rows in Excel does not add cells in Word | Tables |