VBA Novice here: Opening a new Word Document from Excel

[Offroadracer_814]

To All:

I am a VBA novice. However, I can not figure out how to write VBA code to open a new Word Document from Excel.

Can anyone assist in this?

All I need is to open a blank new word document. Then I 'think" I can figure out how to copy and paste from Excel to Word.

Thanks

Kevin

 

[Domenic]

Here's an example that uses early binding. First, set a reference to the Word object library as follows...

Visual Basic Editor >> Tools >> References >> check/select Microsoft Word Object Library >> OK

Then try the following...

Option Explicit

Sub test()

    Dim wdApp As Word.Application
    Set wdApp = New Word.Application
  
    wdApp.Visible = True
  
    Dim wdDoc As Word.Document
    Set wdDoc = wdApp.Documents.Add
  
    'etc
    '
    '
  
End Sub

For additional information, have a look at the following Microsoft reference article...

Documents.Add method (Word)

Office VBA reference topic

learn.microsoft.com

Hope this helps!

 

[Offroadracer_814]

That works. I also did not have the "Visual Basic Editor >> Tools >> References >> check/select Microsoft Word Object Library >> OK" selected. I had the Microsoft Office Object Library selected. Thinking that would cover Word.