Calling a common network file from form

[lucy1216]

I am trying to call a file which is located on a common network drive from a form. Can someone help?



I am using Access 2007.

[lucy1216]

Nevermind...got it:

Private Sub Command125_Click()

Dim LWordDoc As String
Dim oApp As Object
'Path to the word document
LWordDoc = "G:\COMMON\Wireless Telecommunications Approval\Resources\Rate Plans.doc"
If Dir(LWordDoc) = "" Then
MsgBox "Document not found."
Else
'Create an instance of MS Word
Set oApp = CreateObject(Class:="Word.Application")
oApp.Visible = True
'Open the Document
oApp.Documents.Open FileName:=LWordDoc
End If
End Sub