Macro - Open Word with Excel macro

[Bill]

Hello,

Can I launch Word from within an Excel macro? If so, how?

Bill

 

[FxM]

Bill a écrit :

Hello,

Can I launch Word from within an Excel macro? If so, how?

Bill

Hi Bill,

Something like :
Sub test()
Set ww = CreateObject("word.application")
ww.Visible = True
End Sub

HTH
FxM

 

[Nick Hodge]

Or using early binding (You will need to manually set a reference to the
Word Object Library through Tools...>References... in the VBE)

Sub RunWord()
Dim wd As Word.Application
Set wd = New Word.Application
wd.Visible = True
End Sub

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
[email protected]

 

[Bill]

Thanks FxM, Nick

Or using early binding (You will need to manually set a reference to the
Word Object Library through Tools...>References... in the VBE)

Sub RunWord()
Dim wd As Word.Application
Set wd = New Word.Application
wd.Visible = True
End Sub

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
[email protected]