View Single Post
 
Old 12-05-2008, 02:31 AM
HOmT398 HOmT398 is offline
Novice
 
Join Date: Dec 2008
Posts: 1
HOmT398 is on a distinguished road
Default

Hi,jmarin

here is a sample, hope can help you.
Code:
Sub test()
    Dim wrdApp As Object
    Dim myDoc As Object

    Set wrdApp = CreateObject("Word.Application")
   
    With wrdApp
        .Visible = False
        Set myDoc = .Documents.Open("e:\test.doc")
        myDoc.Bookmarks("Region").Range.Copy
        Sheet1.Range("A1").PasteSpecial xlPasteValues
        Application.CutCopyMode = False
    End With
   
    myDoc.Close True
    wrdApp.Quit
    Set myDoc = Nothing
    Set wrdApp = Nothing
End Sub
Reply With Quote