Extract data in a particular form field from multiple templates

[Bob Hansell]

Hi
We are using Word 2000 online forms. I'd like to be able to search a folder
containing many documents based on the same template and extract data from
the same form field within each document into Excel for data analysis. Is
there a way of doing this? Ideally I'd like to reference the data from each
document to the name of the file so we can go to the document later on.

Hoping someone can help
Thanks, Bob

 

[Doug Robbins]

Use the .Name function to get the name of the document and the .Result
property of the formfield to get the data in a modification of the macro in
the article "Find & ReplaceAll on a batch of documents in the same folder"
at:
http://word.mvps.org/FAQs/MacrosVBA/BatchFR.htm


--
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

 

[Bob Hansell]

Many many thanks for your reply Doug - this could save me and my colleagues
hours and hours of work.

Bob