Opening a specific project from MS Access

[microsoft]

I have saved my projects to an Access 2000 database.
In Access, I have a form that shows general project information for all
projects.
What I want to do is to open Project 2000 and open the project that is on
the screen.

I have used:

Dim stAppName As String
Dim pj As Object
stAppName = "C:\Program Files\Microsoft Office\Office\winproj.exe
\\cismernf43\development\ot3\spdrman\dev\projects.mdb"
Call Shell(stAppName, 1)

this opens project 2000, but it only gets to the file/open dialog. I then
have to choose which project to open.
What I want is to be able to pass the project name and open the correct
project programmatically.

Any help is appreciated.

steve

 

[Tim]

Hi, I have used the following code successfully with
Access Xp and Project 2002. Hope it helps:

Dim oApp As Object

Set oApp = CreateObject("MSProject.Application")
oApp.Visible = True
oApp.FileOpen "c:\test.mpp"
Set oApp = Nothing