| Analysis Resource for many projects Posted: 21 Apr 2004 08:46 AM PDT Good evening Verossa,
Try the following VBA procedure. I tested on only 3 WBS levels, but you
could adapt it for more.
The VBA procedure uses the Text10 and the Flag1 fields. You can change that.
Hope this helps,
Gérard Ducouret [Project MVP]
PragmaSoft ® - Paris
Sub Tache_Projet()
Dim oTache As Object, NomProj As String
For Each oTache In ActiveProject.Tasks
If Not oTache Is Nothing Then
oTache.Text10 = oTache.Name 'Copie de sécurité...
If oTache.Flag1 = False Then 'pour ne pas insérer le nom 2 fois
If oTache.Parent = "Microsoft Project" Then
NomProj = oTache.Name
GoTo Suite
End If
If oTache.Parent.Parent = "Microsoft Project" Then
NomProj = Left(oTache.Parent.Name, Len(oTache.Parent.Name) -
4)
GoTo Suite
End If
If oTache.Parent.Parent.Parent = "Microsoft Project" Then
NomProj = Left(oTache.Parent.Parent.Name,
Len(oTache.Parent.Parent.Name) - 4)
GoTo Suite
End If
Suite:
oTache.Name = NomProj & " " & oTache.Name
oTache.Flag1 = True
End If
End If
Next
End Sub
"Verossa" <microsoft.com> a écrit dans le message de
news:com...
project file contains 4 individual projects and I need the output to be
displayed with some type of project identifer. At the present, all the
resources are lumped together and I cannot see which project they correspond
to.
Is there a VBA macro I can purchase to enable this functionality? In actual
fact is there a resource that sells MS Project VBA Macro's that add
additional functionality?
posts (...and I thought the worst was over)
|
| Analyze Timescaled Data for resources in master schedule Posted: 21 Apr 2004 01:26 AM PDT Hey Gerard
Chelsea v Monaco - Oh well, Monaco deserved to win based on that performance
I think I know need to develop a resource pool. The unfortunate thing about having to do this is managing other project managers who are unwilling to provide the visibility to successfully deliver this task
Rod provided one answer - but I think the resource pool is the best method. Do you have any ideas on my second post regarding resources / multiple projects and exporting to MS Excel
Thanks for the assistance - Vers
|
| Resources Filter Posted: 21 Apr 2004 12:16 AM PDT Morning Gerard
Thanks for the response - that's exactly what I am doing! Thanks for pointing that out. The after-effects of Chelsea v Monaco are slowing my brain
Have a good day
Verossa
|
| Microsoft Poject 98 version Posted: 20 Apr 2004 04:58 PM PDT Hi Steve,
Welcome to this Microsoft Project newsgroup :-)
Please see FAQ Item: 18. Memory Problems
FAQs, companion products and other useful Project information can be seen at
this web address: http://www.mvps.org/project/
Hope this helps - please let us know how you get on :-)
Mike Glen
Project MVP
Jeff Chapman wrote:
|
| Critical path Posted: 20 Apr 2004 04:31 PM PDT "Critical" does not mean important or crucial. It is a specific
technical use of the term to mean "a delay in a critical task will
result in a delay in the project completion."
--
Steve House
MS Project MVP
Visit http://www.mvps.org/project/faqs.htm for the FAQs
"Chuck" <microsoft.com> wrote in message
news:1eff01c4272f$8c96dd60$gbl...
|
| report Posted: 20 Apr 2004 01:24 PM PDT Hi Carl,
Glad to know the first answer helped most of the way. I
have been racking my brain to come up with an answer to
your question below.
No joy yet, but I'll keep working on it and perhaps
someone else from the group can answer it in the meantime.
regards,
Julie
the
usage
heading
in
|
| Insert Project into the Master Schedule Posted: 20 Apr 2004 01:16 PM PDT Thanks that helps
task (at the right
dans le message de
If
I
how
|
| Milestone Summary Posted: 20 Apr 2004 12:36 PM PDT Thanks Gerard. I had to substitutue commas for the semi-colons, but it worked fine. It also gave me some additional ideas for setting conditional situations. Best regards, JH
|
| Format Gantt bars to break for overnight nonworking time Posted: 20 Apr 2004 11:50 AM PDT Julie, thank you so much. That is just what I needed. Once again,
these newsgroups have helped me out. I appreciate your response;
thanks again.
Shaun
"JulieS" <microsoft.com> wrote in message news:<1ba201c4270d$f1999990$gbl>...
|
| Preleveled Start/Finish Do not equal start/finish Posted: 20 Apr 2004 09:57 AM PDT Hi Norman,
Read carefully, I mean litterally what I write.
When I say you have to do an explicit round of clear leveling, that is an
explicit, extra run of clear leveling, not just putting "clear leveling
values before leveling", no, go to tools, resource leveling, click clear
leveling and then again tools, resource leveling, level now.
The "clear leveling values" tick doesn't play any part in this preleveled
start story.
HTH
--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/index.htm
32-495-300 620
"Norman Sanin" <com> schreef in bericht
news:phx.gbl...
copying
I
corresponding
leveling.
leveled
Remark
remove."
appreciated.
|
| add orange to ghantt bar Posted: 20 Apr 2004 08:38 AM PDT Could be,but as a color for font it is present in Word (not to highlight) And AFAIK all cultures in the world recognize it as a traffic light color.. -- Jan De Messemaeker Microsoft Project Most Valuable Professional http://users.online.be/prom-ade/index.htm 32-495-300 620 "Mark Durrenberger" <com> schreef in bericht news:phx.gbl... |
| Start and End Times Posted: 19 Apr 2004 03:14 PM PDT .... damn; I wish all things were that easy.
Thanks
"JulieS" <microsoft.com> wrote in message
news:13e201c42663$015d3540$gbl...
|
| Ganatt View, End Dates Posted: 19 Apr 2004 01:51 PM PDT OK Christine,
1. Try Format/Test Styles.
2. You neet to set a Finish No Earlier Than constraint on the appropriate
tasks. Not a recommended technique as your project will lose flexibility
and limit what you can do to manage slippage, etc.
Mike Glen
Project MVP
Christine wrote:
|
