Getting data from Word forms into Excel

L

Libby

Hi there,

I've inherited about 1000 returned Word forms which include various fields -
textboxes checkboxes etc.
They're all the same form, just different info.

I need to get the data from each form into Excel with a column title for
each field, be it a checkbox or whatever. Does anyone know of a bit of code
to do this.
I can already loop through Word docs in a folder, it's just getting the info
from fields and adding it to a new row in a spreadsheet that I'm struggling
with.

Many thanks in advance
 
B

Barb Reinhardt

Send me an email to WitchyWomanMD at Comcast dot Net and I can send you
something that might get you started.
 
B

Barb Reinhardt

I just realized that the file I have converts from one Word doc to an excel
workbook, I'm not sure it's going to work for you. If you'd send a couple of
sample files to extract, I can see what I can come up with. It might take a
few days because I'm pretty busy this weekend.
 

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