Open file from disc

[Lodewijk Olthof]

On my form I have the following fields
cboReference (containg the name of a file without extension)
txtPath (containing the full path to the document)
txtFileType (containing the type of file; Word, Access, Excel, PowerPoint)

Know I want to create a button to open that specific file.
With the Select Case statement on txtFileType I can find out what type of
file I have to open. When it is a Word document, I have tot open the file
txtOpenDocument = txtPath & cboReference & ".doc".

To open Word I can use something like Set oApp =
CreateObject("Word.Application") and then oApp.Visible = True.
But how do I get the txtOpenDocument in Word?

Lodewijk

 

[Arvin Meyer]

If you want to open a specific file in word or any other registered program,
try using ShellExceute:

http://www.mvps.org/access/api/api0018.htm

--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access