linking m/soft word with excel workbook

[JustinR6]

Hello
Can anybody out there help me. I'm trying to open microsoft word from an excel spreadsheet. Is there a way i can do it using a button and macro?
Thanks for your help.
Justin

 

[Yogi39]

sub open_word
Application.ActivateMicrosoftApp xlMicrosoftWord
end sub

 

[Yogi39]

Got this from the help in VB editor...


ActivateMicrosoftApp Method
See Also Applies To Example Specifics
Activates a Microsoft application. If the application is already running, this method activates the running application. If the application isn't running, this method starts a new instance of the application.

expression.ActivateMicrosoftApp(index)

expression Required. An expression that returns an Application object.

index Required XlMSApplication. Specifies the Microsoft application to activate.

XlMSApplication can be one of these XlMSApplication constants.
xlMicrosoftWord
xlMicrosoftPowerPoint
xlMicrosoftMail
xlMicrosoftAccess
xlMicrosoftFoxPro
xlMicrosoftProject
xlMicrosoftSchedulePlus

Example
This example starts and activates Word.

Application.ActivateMicrosoftApp xlMicrosoftWord