Create a .doc file in VBA Excel

[Helder Barros]

How can I create a .doc file and writing thing in that document using VBA in Excel?

Any one have some exaple to do it?

Thanks in advance,

Hélder Barros

[RobDog888]

Yes, in Excel VBA IDE you just need to add a reference to MS Word xx.0 Object Library. And then code like below.

Option explicit
'Add a reference to MS Word xx.0 object library
Private Sub CommandButton1_Click()
    Dim oApp as word.application
    dim oDoc as word.document
    set oapp = new word.application
    set odoc = oapp.documents.add 'Adds a new blank doc
    odoc.activate
    odoc.select
    selection.TypeText Text:="Hello from Excel VBA"
    odoc.save
    odoc.close
    set odoc = nothing
    oapp.quit
    set oapp = nothing
End sub