Morning All,

I have an app where the database creates an 'info' doc in Word and saves it automatically in a specified directory using a unique name composed of the customer's name and ID.

I need some code to retrieve that document, i.e to simply open it in Word for editing. Any ideas would be greatly appreciated.

Cheers

    Dim stAppName As String
    Dim VFile As String

    VFile= whatever formula you use to create the file name

    stAppName = "C:\Program Files\Microsoft Office\Office\WINWORD.EXE " & VFile
    Call Shell(stAppName, 1)



Hope this helps.



[LGuzman]