Macro - Open Word with Excel macro
 

Hello,

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

Bill

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

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
HIS


"FxM" wrote in message
...
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

Thanks FxM, Nick

"Nick Hodge" wrote in message
...
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
HIS


"FxM" wrote in message
...
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