Yes, this is not hard to do. I recommend giving each textbox a name (in Word) so that they can be referred to clearly in your code. Here is an example of some code that reads Word textboxes and places the values in worksheet cells. This example also reads a set Word form checkbox values.
Note that in this example cell B1 on the active worksheet contains the name of the Word form to be read.
Dim Wd As Object
Set Wd = GetObject([b1].Value)
'Read data from word onto spreadsheet
[b3] = Wd.formfields("TitleTB").Result
[b4] = Wd.formfields("OriginatorTB").Result
[b5] = Wd.formfields("DateTB").Result
[b6] = Wd.formfields("TimeTB").Result
'Now read checkbox status values
Dim CB As Object
Dim iRow As Integer
iRow = 8
For Each CB In Wd.formfields
If CB.CheckBox.valid Then
Cells(iRow, 1) = CB.Name
Cells(iRow, 2) = CB.CheckBox.Value
iRow = iRow + 1
Set Wd = Nothing
I can't think of any way to do this without the use of VBA. Is there a particular reason for your desire to avoid VBA? Perhaps we could suggest some way of alleviating this problem if you describe it.
One of the advantages of VBA with reading Word forms is that, if you have lots of users submitting forms, VBA can be used to automatically read and loop through all the forms (for example, all forms in a particular folder) and tally the results.
OMG, so I am just trolling through my "since you last visited" and found this one which I forgot about...
if anyone cares, i just don't know much about vba, just learning right now, but I think I may try this out and see if I can't get it to work for me. I believe I fixed that particular problem by entering the information in Excel and Mail merging my individual word docs for printing.