Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Export Drop-Down List Items
Is there a way to export the contents of a Drop-Down List from a Word Form
Document to use in another application? For example I have a drop-down list called PartNumber. The PartNumber contains 25 items for the user to select. How can I get all 25 items exported out to a file so that I can use in another application. I have a lot of Drop-Down List in this Word form and would like to be able to export all the contents of these Drop-Down List from this form. THANKS!! |
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Export Drop-Down List Items
Run the following code in a macro on exit from one of the formfields in the
document: Dim mydrop As FormField, i As Long Dim target As Document, source As Document Set source = ActiveDocument Set target = Documents.Add For Each mydrop In source.FormFields If mydrop.Type = wdFieldFormDropDown Then target.Range.InsertAfter "The entries for " & mydrop.Name & " a" & vbCr For i = 1 To mydrop.DropDown.ListEntries.Count target.Range.InsertAfter mydrop.DropDown.ListEntries(i).Name & vbCr Next i End If Next mydrop -- 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 "rchampine" wrote in message ... Is there a way to export the contents of a Drop-Down List from a Word Form Document to use in another application? For example I have a drop-down list called PartNumber. The PartNumber contains 25 items for the user to select. How can I get all 25 items exported out to a file so that I can use in another application. I have a lot of Drop-Down List in this Word form and would like to be able to export all the contents of these Drop-Down List from this form. THANKS!! |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Best way to format a list of action items with responsibilities? | Page Layout | |||
Conditional Drop down list?? | Microsoft Word Help | |||
Drop down list from another drop down list in Word? | Microsoft Word Help | |||
How do I create a drop down list in a form using Word? | New Users | |||
In a Word list style, allow different format on first/last items | Page Layout |