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 news:uJNDUNtGIHA.5328@TK2MSFTNGP05.phx.gbl... > 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 > >
