Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Excel as data source?
I have a table in MS Word and i want when users type in #80282 in one of the
cell in the table (in MS Word), it will look up my excel file for that code and have the details about that code (like product ID, price etc) added automatically into my Word's table. Is that possible? |
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Excel as data source?
Hi ?B?VXNlcg==?=,
I have a table in MS Word and i want when users type in #80282 in one of the cell in the table (in MS Word), it will look up my excel file for that code and have the details about that code (like product ID, price etc) added automatically into my Word's table. Is that possible? Not directly, no, as there's no way to trap keystrokes in Word. Indirectly, yes. It would require a macro solution, and you'd have to consider what you want to use a the "trigger" for the macro to execute. You could have the user press a particular key combination, you could use the SelectionChange event, or perhaps you could use form fields and assign it to the exit property of the textbox form field in the table cell. The basic code for accessing Excel information from within Word you'll find at word.mvps.org. For further help on realizing your project, you should ask in a word.vba newsgroup as you'll find more people there who can help you. Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004) 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 | |||
Problems connecting to Excel data source | Mailmerge | |||
Word 2002 cannot find its Excel data source for mail merge | Mailmerge | |||
Error finding excel data source | Mailmerge | |||
Mail Merge Issue With Office 97 - Excel Data Source | Mailmerge | |||
Mail merge error occurs when filtering Excel data source | Mailmerge |