Extracting Form Field Data from Multiple Word Files...

Hello,

I've distributed a form protected for fields and several of these will
return to me each day. I have about 20 fields with bookmarks in the form and
would like to extract the data from these files in a batch process to an
Access table.

I also have tried the code found at
http://gregmaxey.mvps.org/Extract_Form_Data.htm, but I get an error right
from the start with:
Dim vConnection As New ADODB.Connection

???

I hope someone can help me build this solution. I really don't know VBA. It
feels like I'm learning it the hard way...

Thanks!

Raymond

You apparently missed the information line immediately above

'Requires reference to MS ActiveX Data Objects 2.8 Library

From the VBA editor tools references - tick the check box against
Microsoft ActiveX Data Objects 2.8 Library
There's no 'easy' way to learn vba

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


Raymond wrote:
Hello,

I've distributed a form protected for fields and several of these will
return to me each day. I have about 20 fields with bookmarks in the
form and would like to extract the data from these files in a batch
process to an Access table.

I also have tried the code found at
http://gregmaxey.mvps.org/Extract_Form_Data.htm, but I get an error
right from the start with:
Dim vConnection As New ADODB.Connection

???

I hope someone can help me build this solution. I really don't know
VBA. It feels like I'm learning it the hard way...

Thanks!

Raymond

This, and a few more tweeks, got it goin' for me!

Thank you very much!

Raymond

"Graham Mayor" wrote in message
...
You apparently missed the information line immediately above

'Requires reference to MS ActiveX Data Objects 2.8 Library

From the VBA editor tools references - tick the check box against
Microsoft ActiveX Data Objects 2.8 Library
There's no 'easy' way to learn vba

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


Raymond wrote:
Hello,

I've distributed a form protected for fields and several of these will
return to me each day. I have about 20 fields with bookmarks in the
form and would like to extract the data from these files in a batch
process to an Access table.

I also have tried the code found at
http://gregmaxey.mvps.org/Extract_Form_Data.htm, but I get an error
right from the start with:
Dim vConnection As New ADODB.Connection

???

I hope someone can help me build this solution. I really don't know
VBA. It feels like I'm learning it the hard way...

Thanks!

Raymond