Discussion Locked

Form Data from Word into Excel

0 helpful
5 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Has anyone any idea to export the data from a form fiels in MS Word to a database or spreadsheet. I seem to remember doing this some time ago but can't for the life of me remember how HELP

5 replies

by dklippert

From thee forums:

To do this:
1. In Word, open the document that was filled in as a form.
2. Choose Tools>Options, click the Save tab.
3. Add check mark to Select the Save data only for forms, click OK
4. Choose File>Save As.
5. Type a file name in the File name box.
6. In the Save as type box, select Text Only, click Save

Word saves the form field data in a comma-delimited text file, which you can import into Excel.

by jerry e

Try using Word automation

set appWord = CreateObject("Word.Application")

Look at the object model and get the data from the fields. There can be formfields, Mailmergefields, tables and just fields

This discussion is closed to new replies.