Getting data from Word forms into Excel
 

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

Getting data from Word forms into Excel
 

Send me an email to WitchyWomanMD at Comcast dot Net and I can send you
something that might get you started.
--
HTH,
Barb Reinhardt



"Libby" wrote:

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

Getting data from Word forms into Excel
 

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.
--
HTH,
Barb Reinhardt



"Libby" wrote:

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