Open a MS Word document from Access

[Ky-Thuan]

Hi,

Does anyone know the VBA code that allows to open a Word
document located in a specific directory?

Many thanks in advance

KT

 

[May]

You may do it in the properties -- > hyperlink address or
go to Tools and References to Register the MS Word first
then

Private Sub Open_Word_Click()
Dim wks As Word.Document
Set wks = GetObject("c:\xxx.doc")
wks.Parent.Visible = True
set wks=nothing
End Sub

 

[Chris]

Easier method:

Shell "Winword.exe ""C:\Folder\Filename.exe"""

Chris