Experienced PM, Project Programming Newbie!

[Lee]

All,

I am an experienced PM and have been using Project for some time now.
However, I have never looked at the programming aspect of Project (Macro's,
VBA, etc) and I think I need to start as I now have a problem which I think
needs this knowledge. My problem is this: -

I have created a project plan in the usual way (adding tasks, indenting
tasks to create Summary tasks, etc) and a Resource Pool with internal and
external resources in it. The internal and external resources have different
hourly rates. I have also created a Custom Field (OK, I've dabbled a little!)
for the Resources which is a text field stating Internal or External,
depending upon their status. I have assigned these resources to all of the
tasks in my plan.

What I want to do is to create an Excel Spreadsheet that lists the
following: -

Row1:
Column1 - Phase Name (These are the level 2 Summary Tasks)
Column 2 - Number of hours of Internal Resource Usage for this Phase
Column 3 - Number of hours of External Resource Usage for this Phase
Column 4 - The total of Internal and External Hours for this Phase

Row2, 3, 4, etc:
The same as Row 1 but for the next Phase in the project.

I have no idea where to start to try and get this out. I have tried several
things but get nowhere. The summary tasks have no resources assigned to them
so I cannot just run a custom report (I think!) to get the info out I am
looking for.

Is this possible? Should I be thinking along the lines of VBA or Macros or
both?

Anyone who can shed some light on this for me would be greatly appreciated!

Kindest Regards

Lee

 

[Mike Glen]

Hi Lee,

Try posting on the developer newsgroup as this one is closing down. Please
see FAQ Item: 24. Project Newsgroups. FAQs, companion products and other
useful Project information can be seen at this web address:
http://www.mvps.org/project/.

Mike Glen
Project MVP

 

[Lee]

Hi Mike,

Do you mean at mvps.org?

Lee

Hi Lee,

Try posting on the developer newsgroup as this one is closing down. Please
see FAQ Item: 24. Project Newsgroups. FAQs, companion products and other
useful Project information can be seen at this web address:
http://www.mvps.org/project/.

Mike Glen
Project MVP

 

[John]

Lee,
If you want to learn VBA, and I recommend you do if you want to make
Project as functional as possible, there is an excellent tutorial link
on the MVP website at:
http://www.mvps.org/project/links.htm
Go to the bottom on the page and find the link for "Project 98 Visual
Basic Environment Training Materials". Although it says it is for
Project 98, the lessons therein are equally applicable to all current
versions of Project. The only difference is that later versions have
expanded the Project Object Library.

For some examples of VBA code, go to Jack Dahlgren's website at:
http://masamiki.com/project/macros.htm
Jack has a variety of VBA code examples posted including one that works
between Project and Excel.

Hope this helps.
John
Project MVP

 

[Mike Glen]

Hi Lee,

No - read the FAQ and it'll tell you the details. You need to open an
account with microsoft.public.project.developer.


Mike Glen
Project MVP

 

[Lee]

Thanks Mike,

However, they seem to be one and the same thing (or at least the content
is!)

 

[Mike Glen]

Sorry, Lee, I don't understand your point. Microsoft wants to close this
newsgroup down and has created the developer newsgroup to take posings on
vba, etc. The FAQ tells you which newsgroup to use in the future.


Mike Glen
Project MVP