Creating a Word Document with Excel VBA

Re: Creating a Word Document with Excel VBA

Hi

Welcome to Ozgrid forum. This is not my code but it can be adapt to what you want.

Sub CreateNewWordDoc()
' to test this code, paste it into an Excel module
' add a reference to the Word-library
' create a new folder named C:\Foldername or edit the filnames in the code
Dim wrdApp As Word.Application
Dim wrdDoc As Word.Document
Dim i As Integer
    Set wrdApp = CreateObject("Word.Application")
    wrdApp.Visible = True
    Set wrdDoc = wrdApp.Documents.Add
    ' or
    'Set wrdDoc = wrdApp.Documents.Open("C:\Foldername\Filename.doc")
    ' sample word operations
    With wrdDoc
        For i = 1 To 100
            .Content.InsertAfter "Here is a sample test line #" & i
            .Content.InsertParagraphAfter
        Next i
        If Dir("C:\Foldername\MyNewWordDoc.doc") <> "" Then
            Kill "C:\Foldername\MyNewWordDoc.doc"
        End If
        .SaveAs ("C:\Foldername\MyNewWordDoc.doc")
        .Close ' close the document
    End With
    wrdApp.Quit ' close the Word application
    Set wrdDoc = Nothing
    Set wrdApp = Nothing
End Sub

Re: Creating a Word Document with Excel VBA

I have a similar problem. I have an excel sheet with multiple columns. Would like to populate that table format in a word doc. Any pointers?

Re: Creating a Word Document with Excel VBA

Why not simply create the report on a sheet within the workbook?

Re: Creating a Word Document with Excel VBA

The simplest way:

Sub M_snb()
    With CreateObject("Word.Document")
        .Windows(1).Visible = True
        .Content = "Example"
    End With
End Sub

Re: Creating a Word Document with Excel VBA

Hi there!
Sorry to ask this, but I am having trouble creating a word document named after the active cell and based on a specific template. After this document is created, the document should open.
Does anyone have a code for that?
Thank you very much!!

Re: Creating a Word Document with Excel VBA

hfalstom

Welcome to the Forum. Please take the time to read our Forum Rules

Please start your own post. Posting in another member's Thread is known as hijacking and is not allowed here. By all means add a link to a Thread that may be related to your question.