Command Button VBA Code

[cheoke]

Is there any way that I can code a command button so that when clicked a word document opens and text appears in the word document??
Thank You

 

[Diablo II]

Private Sub CommandButton1_Click()
Dim wordApp As Object
Dim fNameAndPath As String
fNameAndPath = "c:\MyDoc.doc"
Set wordApp = CreateObject("Word.Application")
wordApp.Documents.Open (fNameAndPath)
wordApp.Visible = True
End Sub

 

[cheoke]

How do I write the code to get text to show up in the new word doc?

 

[Diablo II]

read this
http://support.microsoft.com/kb/q149830/

 

[cheoke]

So I got the excel sheet to write text in a word document, but how would I program another command button to add text to the same word document without creating a new word document?

 

[Diablo II]

post the code you used for the first button, you should be able to use the same button to add all the stuff you wont.