Thread: Command button
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson[_5_] Dave Peterson[_5_] is offline
external usenet poster
 
Posts: 1,758
Default Command button

You have a few options.

You could use Insert|Object and put the word document in the worksheet.

Or you could even use a different object and assign a hyperlink to that word
document.

You could even use that button and have code that opens the word document.

Option Explicit
Private Sub CommandButton1_Click()
Shell "start ""c:\my documents\word\test1.doc"""
End Sub



jungleman wrote:

If I put a COMMAND BUTTON in excel or any other buton, how do I view a
specific word document? Do I insert the document in excel or can I have a
seperate folder in MY DOCUMENTS with all of the WORD files I want to insert?


--

Dave Peterson