If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Extracting Form Field Data from Multiple Word Files...
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 |
#3
|
|||
|
|||
Extracting Form Field Data from Multiple Word Files...
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 |
Thread Tools | |
Display Modes | |
|
|