Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-31-2016, 08:03 AM
surumadurum surumadurum is offline Insert SubProject after Task x? (Linking ConsolidateProjects to Task) Windows 8 Insert SubProject after Task x? (Linking ConsolidateProjects to Task) Office 2016
Novice
Insert SubProject after Task x? (Linking ConsolidateProjects to Task)
 
Join Date: Mar 2016
Posts: 1
surumadurum is on a distinguished road
Thumbs down Insert SubProject after Task x? (Linking ConsolidateProjects to Task)

Hi,

I have to solve the task of dynamically inserting Sub-Projects into a Master-Project at a specific position - which is under a certain "heading" and after all the already inserted SubProjects.

Heading A
Heading Aa
- Project A1
- Project A2
Heading B
- Project B1

My problem is that ConsolidateProjects inserts the project at the current cursor position.
Now I solved it like that:

- collapse / expand all Tasks so that Headings and Subheadings are visible but all Subtasks of Sub-Projects are hidden
- iterate through rows with SelectRow, get task-name with ActiveSelection.Tasks(1).Name
- if it's the right heading, get number of already inserted subprojects with Tasks(from_last_step).OutlineChildren.Count
- Call ConsolidateProjects


- Indent the new inserted project to the correct level

This solution has shown to be very error-prone. The initial indent of the new subproject seems quite random and often the subprojects and up at the wrong position.

Isn't there any solution like "Insert subproject after Task(x), no matter in which row it is displayed at the moment"?

Hope somebody has help!
Reply With Quote
  #2  
Old 04-05-2016, 06:09 AM
JulieS JulieS is offline Insert SubProject after Task x? (Linking ConsolidateProjects to Task) Windows 7 64bit Insert SubProject after Task x? (Linking ConsolidateProjects to Task) Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

Sorry - code is not my skill set. I would have 'big' picture recommended what you are doing - iterate through the task list - find the task by name. I guess you could find the task by GUID which should be maintained during the consolidation.
Reply With Quote
Reply

Tags
consolidateprojects, row, task

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to make a task adjust its end date depending on another task? (Newbie) ravl13 Project 3 07-27-2014 06:10 PM
Insert SubProject after Task x? (Linking ConsolidateProjects to Task) Copy and Paste of a Task...Including all of the Task's 'children'...to a new task KRTSTARRYNIGHT Project 1 07-01-2014 06:54 AM
Insert SubProject after Task x? (Linking ConsolidateProjects to Task) Mid-Task resource scheduled 0 hours increasing task duration needlessly DarlaWeber Project 1 01-31-2014 02:30 PM
Insert SubProject after Task x? (Linking ConsolidateProjects to Task) Linking task duration to another task branchi Project 1 08-15-2013 06:03 AM
Linking a SharePoint meeting to a Project task. mnollar Project 0 12-13-2005 03:58 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:55 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft