Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.docmanagement
rchampine
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.word.docmanagement
Doug Robbins - Word MVP
 
Posts: n/a
Default 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

Posting Rules

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

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Best way to format a list of action items with responsibilities? ChrisB Page Layout 1 January 20th 06 07:33 PM
Conditional Drop down list?? [email protected] Microsoft Word Help 3 January 16th 06 08:36 PM
Drop down list from another drop down list in Word? gobonniego Microsoft Word Help 1 December 20th 05 07:46 PM
How do I create a drop down list in a form using Word? Donna New Users 3 June 21st 05 04:37 PM
In a Word list style, allow different format on first/last items Anita Page Layout 2 June 2nd 05 12:35 PM


All times are GMT +1. The time now is 07:00 AM.

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"