Extract data in a particular form field from multiple templates

B

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
 
D

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
 
B

Bob Hansell

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

Bob
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top