Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.docmanagement
yefiwsbor yefiwsbor is offline
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.word.docmanagement
Cindy M. Cindy M. is offline
external usenet poster
 
Posts: 2,416
Default 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

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I link Word to Excel...?? Chris Gorham Microsoft Word Help 1 January 20th 08 09:15 PM
link word data and excel Cheri G Microsoft Word Help 1 May 11th 07 03:03 PM
2 Excel Workshts in Word - Can you link them? Alesha Microsoft Word Help 1 January 13th 05 11:09 PM
If you add 2 excel workshts in a word doc. is it possible to link Alesha Microsoft Word Help 1 January 11th 05 09:34 PM
Excel Link: Adding rows in Excel does not add cells in Word Jameslp Tables 2 December 9th 04 07:18 PM


All times are GMT +1. The time now is 01:24 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"