Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Using Word to resolve values defined in a csv file
Hi all,
Can Word be configured to use a csv lookup table or an Excel spread sheet? Below are examples of the specifics: Source in the Word doc €¦ Sponsor1233/Sponsor Sponsor44/Sponsor Target output after using the look up €¦ SponsorJOHN BROWN/Sponsor SponsorPAUL WHITE/Sponsor Where there is a csv file generated from an Excel spreadsheet, that reads€¦ Brown,John,1233 White,Paul,44 Green,Nick,9062 .... and so on. If the answer is "yes, Word can do this", how please? Thanks, A1sysman |
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Using Word to resolve values defined in a csv file
I believe you would have to write a VBA program that opens the lookup file
and processes it. That would be much easier to do with the lookup in an Excel spreadsheet rather than a csv. -- TedMi |
#3
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Using Word to resolve values defined in a csv file
Ok, thanks for your reply and suggestion.
I was thinking more along the lines of whether it is possible to use a Word macro to use a csv file in order to resolve UINs to names, then to continue on and use seach and replace of the UINs with a reorder of the date by way of field 2 {space} field1 capitalised, omitting field 3. Does that make sense? I'm too lightweight a user of Word to know if this is possible or, if it is, how to do it! Rgds, N "tedmi" wrote: I believe you would have to write a VBA program that opens the lookup file and processes it. That would be much easier to do with the lookup in an Excel spreadsheet rather than a csv. -- TedMi |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to set the margin values of a word file in c#? | Page Layout | |||
Inserting pre-defined text at pre-defined location upon tick! | Microsoft Word Help | |||
In Word Error 1706 comes up. How can I resolve this? | Microsoft Word Help | |||
Problem arises when ref bookmark is added in the header ,it does not take the modified values and displays the same old values | Microsoft Word Help | |||
Problem arises when ref bookmark is added in the header ,it does not take the modified values and displays the same old values | Microsoft Word Help |