Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 616
  • Last Modified:

Word Automation using Excel VBA

Hi
I want to generate word report using Excel VBA.
0
sachin237
Asked:
sachin237
  • 2
1 Solution
 
rspahitzCommented:
How about this?

shell Application.Path & "\winword"
0
 
SiddharthRoutCommented:
I would suggest Late Binding with Word. Here is an Example.

Since you have mentioned much what you want to do with the report, so I have left that area blank in the code.

Sub OpenWordDoc()
    Dim oWordApp As Object, oWordDoc As Object
    Dim FlName As String
    
    FlName = "C:\MyWordDoc.Doc"
    
    '~~> Establish an Word application object
    On Error Resume Next
    Set oWordApp = GetObject(, "Word.Application")
    
    If Err.Number <> 0 Then
        Set oWordApp = CreateObject("Word.Application")
    End If
    Err.Clear
    On Error GoTo 0
    
    oWordApp.Visible = True
    
    Set oWordDoc = oWordApp.Documents.Open(FlName)
    
    '~~> Perform necessary actions.
    
    oWordDoc.Close Cavechanges:=True
    
    Set oWordDoc = Nothing
    oWordApp.Quit
    Set oWordApp = Nothing
End Sub

Open in new window


Sid
0
 
SiddharthRoutCommented:
I see two typos in the above code.

1) Please read

>>>Since you have mentioned much what you want to do with the report, so I have left that area blank in the code.

as

Since you haven't mentioned much what you want to do with the report, so I have left that area blank in the code.

2) Line 23 in the code

oWordDoc.Close Cavechanges:=True

as

oWordDoc.Close Savechanges:=True

Sorry for the typos.

Sid
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now