Solved

MS Project - access Project Summary Task in VBA?

Posted on 2011-03-17
4
1,892 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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Article by: x-men
Where used to see Gantt charts for illustrating project timelines, but what if I wanted to visualize passed timed events? Here's how.
"Disruption" is the most feared word for C-level executives these days. They agonize over their industry being disturbed by another player - most likely by startups.
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

810 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