N
Nach
Is there a way to Open Projects and it's dependent projects programmatically..?
Save them and close...all through a program..?
Save them and close...all through a program..?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
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
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
N
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.
I open it's sub projects..I'll have to think about it.
R
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
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
J
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
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
N
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
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
N
Nach
Hi...I found a way in MSP_TASKS...it has a field for sub_projects.
N
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.
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.