here is my updated code. It seems as if my code isn't finding my file or opening the word file. If I ' out the Input box, and strDocName, and enter the direct path under GetObject, I then get a "2147467259:Database has been placed in a state by user 'Admin' on machine 'PRA" that...
The line you gave me fixed that error, now I am getting a
"432: File name or class name not found during automation operation"
UGH!
Any ideas? I tried typing the file name in the Input box, then i tried typing the path to the file, same error.
This module is taking data from a Word Form, and importing it into an Access Table.
When I run this Module I get the dialog box to type in the Word Document Name, enter the doc name, then I click OK. This is when I get the "Automation Error - The Server Threw an Exception" dialog...
Now that i have debugged this (added the resources, and updated my field names.)
I am getting the dialog box that asks for my document name to import then I get the following error, after I type in my 9999.doc OK
"-2147417851 Automation Error The Service threw an exception"
Any...
I have the following References selected:
VBA
Access 9.0 Ob Lib
Word 9.0 Ob Lib
OLE Automation
VBA Extensibility 5.3
I am now getting the same error "user-defined type not defined" at:
cnn As New ADODB.Connection
I have found the following code to use as an Access Module to move the data from a Word Form into an Access Table. I am getting a compile error: User defined type not defined at Dim doc As Word.Document. Any suggestions?
ADO procedure to import Word data
Sub GetWordData()
Dim appWord As...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.