Hi All

I am using this code to open word document from access but when you close word document, it ask you save as templete and i found it create process on task manager

I am not sure is this correct way to open and view documnet


here's code

Dim wd As Word.Application
Set wd = New Word.Application
wd.Documents.Open (r!FDestination)
'wd.Application.Documents.Open fileName:=r!Destination,ReadOnly:=True
'wd.Documents.Open r!FDestination, ReadOnly:=True
wd.Application.Visible = True
Set wd = Nothing


Thanks

Ayaz

hi use this code if msword is on d drive.i:e if program files is in d drive then use after the click event of a command button e:g command0


Private Sub Command0_Click()
On Error GoTo Err_Command0_Click

    Dim stAppName As String

    stAppName = "D:\Program Files\Microsoft Office\OFFICE11\WINWORD.EXE"
    Call Shell(stAppName, 1)

Exit_Command0_Click:
    Exit Sub

Err_Command0_Click:
    MsgBox Err.Description
    Resume Exit_Command0_Click

End Sub

if it is on c drive i:e if program files is in c drive then use after the click event of a command button e:g command0
Private Sub Command0_Click()
On Error GoTo Err_Command0_Click

    Dim stAppName As String

    stAppName = "c:\Program Files\Microsoft Office\OFFICE11\WINWORD.EXE"
    Call Shell(stAppName, 1)

Exit_Command0_Click:
    Exit Sub

Err_Command0_Click:
    MsgBox Err.Description
    Resume Exit_Command0_Click

End Sub

Wouldn't wd.Quit do the trick?


-Phil-