Susan Harkins
ssharkins at setel.com
Wed May 9 17:27:35 CDT 2007
Found my error...
Set doc = appWord.Documents("CustomerSlip.doc")
Set doc = appWord.Documents.Open("C:\WordForms\CustomerSlip.doc", , True)
I thought it was an either/or, but apparently it isn't -- you have to set
the document name AND include the document's name in the Open method.
Susan H.
Susan,
Sample subroutine as given below, on being tested at my end, is found to
work smoothly.
Best wishes,
A.D.Tejpal
---------------
Sample subroutine
===============================
Sub P_GetWordDoc()
On Error GoTo ErrTrap
Dim appWord As Word.Application
Dim doc As Word.Document
Dim DocPath1 As String, DocPath2 As String
DocPath1 = "C:\TEMP\Test 01.doc"
DocPath2 = "C:\TEMP\Test 02.doc"
On Error Resume Next
Err.Clear
Set appWord = GetObject(, "Word.Application")
If Err.Number <> 0 Then
Set appWord = New Word.Application
End If
On Error GoTo ErrTrap
Set doc = appWord.Documents.Open(DocPath1, , True)
On Error Resume Next
Kill DocPath2
doc.SaveAs DocPath2
ExitPoint:
On Error Resume Next
doc.Close
appWord.Quit
Set doc = Nothing
Set appWord = Nothing
On Error GoTo 0
Exit Sub
ErrTrap:
MsgBox Err.Number & " - " & _
Err.Description, vbCritical + vbOKOnly, _
"Error Encountered"
Resume ExitPoint
End Sub