Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Data Entry Forms (Data, Worksheet) | Excel Discussion (Misc queries) | |||
Put form fields in Word forms into an Excel spreadsheet? | Excel Discussion (Misc queries) | |||
Print labels by using Excel data in a Word mail into word | Excel Discussion (Misc queries) | |||
Compile/Analyze Word Form Field data from multiple forms? | Excel Discussion (Misc queries) | |||
Emergency! Can I use Maco to export excel data into word forms | Excel Programming |