Opening a Word File

[mikeparks]

How do you create a command button to automatically open a word file from a form. I want my users to open an instructions word file.

 

[dk]

Hi Mike,

You can use code like this:-

Private Sub Command0_Click()
Dim oWordApp As Object


Set oWordApp = CreateObject("Word.Application")
oWordApp.Documents.Open "H:\temp\instructions.doc"
oWordApp.Visible = True

End Sub

 

[t406jaw]

can this be done with a macro? if so how

 

[bat17]

You don't need to use a macro as you can use a hyperlink from a button or label to open your word doc. this has the advantage of letting you jump to bookmarks as well!

The code that DK posted will work from the on click event of a button. You could pull the path from the value in a field in the form rather than hard coding it if you wanted.

HTH

Peter