I have been fighting with this for days and your expert help is
needed! Below is the code I am executing which results with "Object
doesn't support this property or method". The error is occuring on
the "With Me.OLEObject" line (By the way, I haven't found
documentation which explains what the "With" clause is suppose to
do?). I am trying to extract a Word document(OLE object) from an
Access database, for each record in the table, and save it as a Word
Document. The 4th field of each record is a OLE object type.
This is a continuation of my recent post "Exporting/Extracting an
Access OLE object (Word document) to a Word document file" in several
newsgroups.
Thank you for your help!
My Code:
dim conn
set conn = CreateObject("A DODB.Connection ")
conn.Open "provider=micro soft.jet.oledb. 4.0;data
source=C:\work\ srvScripts.mdb"
dim rs
dim NewDoc
set rs = CreateObject("A DODB.Recordset" )
'rs.Open "select * from tblTemp", conn
rs.Open "tblTemp", conn
'rs.BOF and rs.EOF = True means that there is no records
rs.MoveFirst
while not rs.EOF
set srv = rs.Fields(1)
set ttl = rs.Fields(2)
NewDoc = "c:\tst\" & srv & "." & date() & "." & ttl & ".doc"
' WScript.Echo NewDoc
With Me.OLEObject
.Class = "Word.Docum ent"
.Verb = acOLEVerbOpen
.Action = acOLEActivate
.Object.Applica tion.Documents. Item(1).SaveAs NewDoc
.Object.Applica tion.Quit
.Action = acOLEClose
End With
rs.MoveNext
wend
needed! Below is the code I am executing which results with "Object
doesn't support this property or method". The error is occuring on
the "With Me.OLEObject" line (By the way, I haven't found
documentation which explains what the "With" clause is suppose to
do?). I am trying to extract a Word document(OLE object) from an
Access database, for each record in the table, and save it as a Word
Document. The 4th field of each record is a OLE object type.
This is a continuation of my recent post "Exporting/Extracting an
Access OLE object (Word document) to a Word document file" in several
newsgroups.
Thank you for your help!
My Code:
dim conn
set conn = CreateObject("A DODB.Connection ")
conn.Open "provider=micro soft.jet.oledb. 4.0;data
source=C:\work\ srvScripts.mdb"
dim rs
dim NewDoc
set rs = CreateObject("A DODB.Recordset" )
'rs.Open "select * from tblTemp", conn
rs.Open "tblTemp", conn
'rs.BOF and rs.EOF = True means that there is no records
rs.MoveFirst
while not rs.EOF
set srv = rs.Fields(1)
set ttl = rs.Fields(2)
NewDoc = "c:\tst\" & srv & "." & date() & "." & ttl & ".doc"
' WScript.Echo NewDoc
With Me.OLEObject
.Class = "Word.Docum ent"
.Verb = acOLEVerbOpen
.Action = acOLEActivate
.Object.Applica tion.Documents. Item(1).SaveAs NewDoc
.Object.Applica tion.Quit
.Action = acOLEClose
End With
rs.MoveNext
wend
Comment