Open Projects programmatically

[Nach]

Is there a way to Open Projects and it's dependent projects programmatically..?
Save them and close...all through a program..?

 

[Rod Gill]

Yes. VBA handles this just as you would manually. I assume dependent
projects means sub-projects?

--

Rod Gill
Project MVP

Project VBA Book, for details visit:
http://www.projectvbabook.com

NEW!! Web based VBA training course delivered by me. For details visit:
http://projectservertraining.com/learning/index.aspx

 

[Nach]

Yes...sub-projects. I do know how to open one project and save it..but how do
I open it's sub projects..I'll have to think about it.

 

[Rod Gill]

Look at the Subprojects property. It provides a collection of all
subprojects. So:

Sub test()
Dim subProj As Subproject
For Each subProj In ActiveProject.Subprojects
FileOpen subProj.Path
Next
End Sub


--

Rod Gill
Project MVP

Project VBA Book, for details visit:
http://www.projectvbabook.com

NEW!! Web based VBA training course delivered by me. For details visit:
http://projectservertraining.com/learning/index.aspx

 

[Jan De Messemaeker]

Hi,

I generally use this variation on Rod's theme

Set ThePr=subpr.sourceproject
HTH

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf

 

[Nach]

Thanks for pointing me in the right direction! I tried it on a few
projects..but lookslike they dont have a subproject. Is there a way to know
which projects have a subproject from the database..? So i can test this only
that project instead of opening and closing all the projects.

Thanks
Nach

 

[Nach]

Hi...I found a way in MSP_TASKS...it has a field for sub_projects.

 

[Nach]

Hi...I just came to know. By dependent projects I didnt mean subprojects...i
wanted to mean predecessors and successors. Each external project that this
project is linked to. I tried using VBA and TaskDependency methods to
retreive that information..but it is kind of redundant..I just want distinct
predecessor and successor projects..so I decided to just use an SQL
query..get the record set and then process it in VBA. I'll get back with
questions as I progress on this thought and encounter more difficulties on
this.