Word to excel

  • Thread starter Thread starter Brad
  • Start date Start date
B

Brad

Can I take information from a checkbox in word and put it into excel?
what I have so far is

Sub OpenDoc()
Dim WordApp As Object
Set WordApp = CreateObject("Word.Application")
WordApp.Documents.Open "Group annuity\language premiums.docx"
WordApp.Visible = True
ShtInput("a1").Value = WordApp.formfield("403B").CheckBox.Value
End Sub

But the last line isn't being accepted - I expect that the "formfield" is
not correct...

I purposely shortened the WordApp.Documents.Open line for readability
It would be nice just to grab the information and not have to "open" the
document.
 
In a nutshell - I want to take information from a checkbox but the "results"
in Excel.


Couple more items to add from the original post - using 2007
Tools - reference - added Microsoft Word 12.0
Changed
shtInput("a1").value
to
shtinput.range("a1").value
 
Back
Top