Solved

MS Project - access Project Summary Task in VBA?

Posted on 2011-03-17
4
1,845 Views
Last Modified: 2012-06-27
Is there a way to access the Project Summary Task in vba (when Show Project Summary Task is checked in Options | View)? When the mpp is exported to Excel, the Project Summary Task, with ID 0, is included, but when I traverse the tasks in VBA (For Each Task In
ActiveProject.Tasks) The Project Summary/TaskID 0 is not included, but if it has child tasks they are included. The resulting recordset doesn't make much sense.

I have an automation project that needs the Project Summary Task, if it is selected in the mpp. I suppose I could save the mpp to xls before working with the tasks in vba, but I'd rather avoid that step if possible.
0
Comment
Question by:dgmoore1
  • 3
4 Comments
 
LVL 12

Expert Comment

by:thausla
ID: 35171903
You can use the project summary task with ActiveProject.Tasks.UniqueID(0). This is independent from the settings in Options..View.
0
 

Author Comment

by:dgmoore1
ID: 35172011
Interesting. I wonder why it isn't returned when you iterate For All Tasks in ActiveProject.Tasks...  I'll try this in my code and see what I get
0
 

Accepted Solution

by:
dgmoore1 earned 0 total points
ID: 35461933
I have determined that in order for the procedure I have developed to work correctly, the project summary task must be in MSP_TASKS. I am instructing my users not to employ Project's Show Project Summary Task.
0
 

Author Closing Comment

by:dgmoore1
ID: 35496484
Determined that the project summary task, if used, must be in the Tasks table.
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Suggested Solutions

Re-planning is just as important as planning. MS Project files need to be updated regularly to reflect the current status of the project and to streamline the upcoming tasks. We have seen a lot of issues where project managers have not updated the p…
Online collaboration is quickly becoming embedded in the workplace, and its benefits are tangible. See what the current landscape looks like and what the future holds for collaboration tools and the future of work.
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now