command button in ms Excell that loads a help file in ms word

reference the word lib. then
dim objWord as Word.Application
set objWord = new Word.Application

okay that makes sense,  apart from  the reference part .
what do you mean?

the word libary?
cheers!!!

okay okay i got it to work  at last!
even mananged to work out how to point to a path

thanx!!


can i just ask do you know any where online where i will find info  to make a button that opens an outlook window and attaches the excel file to it?

thanx for any help

Private Sub cmdsend_Click()
' This procedure is a brief sample showing
' how to automate Outlook.

' Remember to set a reference to the most current available
' Microsoft Outlook oject library.

    Dim appOutl As Outlook.Application
    Dim maiMail As MailItem
    Dim recMessage As Recipient
    Dim booRecip As Boolean
   
    ' Set a reference to the Outlook Application object.
    Set appOutl = New Outlook.Application
   
    ' Set a reference to the MailItem object.
    Set maiMail = appOutl.CreateItem(olMailItem)
   
    With maiMail
        ' Get an address from the user.
        Set recMessage = .Recipients.Add(InputBox("Enter name of message recipient", "Recipient Name"))
       
        ' Attempt to resolve the recipient against an address book.
        booRecip = recMessage.Resolve
       
        ' Add subject and body text.
        .Subject = "Testing mail by Automation"
        .Body = ActiveDocument.Content

       
        ' Send the mail.
        .Send
   
    End With
   
    ' Close object references.
    Set appOutl = Nothing
    Set maiMail = Nothing
    Set recMessage = Nothing

 End Sub


i used this code but it didnt like   this line
     .Body = ActiveDocument.Content
said there was no active document
ehhh???

You probably want it as an attachment and not in the body of the message so change the .Body part in:

 .Attachments.Add "c:\test\test.xls"

You have to save your excel sheet first in order to attach it.

okay, say i have e-mailed you the form, and you have opened it from outlook. entered the information and then clicked on the form,
the location of the file isnt going to be on my hard drive  it would be on theirs.
how would i be able to re atach that so it gets sent back

would it still be  .Attachments.add    and then something different,
there is no way of knowing what their drive would be as were all on a network, and use our id numbers as our sharted space on the network

thanx for all your help!!!

as usual from this place,  another excellent answer from wonderful people who dont mind explaining easy concepts to dum people