Grouping Tasks Microsoft Project |
- Grouping Tasks
- Hour control of how else ?
- Creating a Project with VBA (MS Project 2003 Pro)?
- Historic Resource Costs
- Why are tasks being assigned to non-working days?
- Vacation Schedules on Large Projects How do you handle them - Best
- VB problem
- VB offset error from Jack Dahgren's Code
- Resource Calculations
- A new year
- How to hide inactive resources
- zooming in on task pane - not gantt chart
- colour code milestones in calendar view?
- Constraint - Start no earlier than
- Saving Reports to MS Word
- Work Week MSP98 (Newbie Question)
- Wrap text in Microsoft Project 2000
- Visual Basic Code
- Critical Path - Critical Chain Tracking of Projects
- Predecessor Driven Completion
- time phased network diagram
- PPBES and Project
- Hiding Subproject summary tasks?
- Task splitting - a process, not a parameter?
Posted: 01 Nov 2005 06:10 AM PST In article <com>, Jim Jones <microsoft.com> wrote: Jim, It sounds like the Grouping function is what you want. Look for "Grouping" in the Project help file. Hope this helps. John Project MVP |
Posted: 01 Nov 2005 05:57 AM PST In article <com>, "Jan H-L" <microsoft.com> wrote: Jan, First of all, you shouldn't be entering either the task Start or Finish, that's Project's job. Except in a few isolated cases (e.g. a task starts independently of all other tasks and does not start when the project starts), the task information you should be entering are: 1. Task Name - performance tasks should be in action verb format 2. Task Duration - whether in minutes, hours, days, etc. (Note: Task Duration is NOT the same as Work effort although if a resource is assigned at 100% the values in those two fields will be the same.) 3. Linkages between tasks - this sets up the logical flow of the activities - the default is finish-to-start 4. Resource assignments - the people or material necessary to complete the task Given the above information, Project calculates a schedule. That is, it will set up all task start and finish dates (and times if the option to display time is selected under Tools/Options/View tab). Project will also calculate Cost based on the resource pay rate x Work hours plus any Fixed Cost associated with the task. The user "controls" resources and cost by developing a realistic plan and good project management techniques (e.g. workarounds when things don't go as originally planned). For some good reference material, you might want to go to our MVP website at: http://www.mvps.org/project/links.htm and take a look at fellow MVP, Mike Glen's series on Project lessons and techniques. Hope this helps. John Project MVP |
Creating a Project with VBA (MS Project 2003 Pro)? Posted: 31 Oct 2005 03:19 PM PST I copied it to the Developers Newsgroup for MS Project. "Mike Glen" wrote: |
Posted: 31 Oct 2005 01:36 PM PST Gerard, Hello. yes I posted that last question too. I was hoping someone could point me in the right direction for coding advice as I cannot do this all by hand with so many employees. Unfortunately, like many others I have inherited this ms project file... Do you know of any other places I can look for a little VBA/ MS project help with this? Thanks so much! Jenn "Gérard Ducouret" wrote: |
Why are tasks being assigned to non-working days? Posted: 31 Oct 2005 11:57 AM PST JodyC -- To which calendar did you add the holidays? Is this calendar set as the Base Calendar for each resource listed in the Resource Sheet view of your project? Let us know. -- Dale A. Howard [MVP] Enterprise Project Trainer/Consultant http://www.msprojectexperts.com http://www.projectserverexperts.com "We wrote the book on Project Server" "JodyC" <microsoft.com> wrote in message news:com... |
Vacation Schedules on Large Projects How do you handle them - Best Posted: 31 Oct 2005 08:20 AM PST We are not using server - they have ordered it along with SQL, so maybe in the future it will be running for us but that will be to late as I need to find something to manage now. I do not want to manage it in excel as I want Proj to adjust dates to tasks when people have vacation. WIth 80 people and 3 weeks vacation min. for everyone, forgetting about all that time off would be a mistake. Have any other thoughts? Maybe someone else will have some ideas for me? "Michael Balda" wrote: |
Posted: 31 Oct 2005 08:10 AM PST In article <com>, "WD" <microsoft.com> wrote: WD, What exactly are you referring to when you say, "... the set ref command ...."? The only way I know to set references is via the "addfromfile" or "addfromguid" and either of those must be set with an event macro prior to attempting to run a macro where the reference is required. But I'm always willing to learn new techniques. John Project MVP |
VB offset error from Jack Dahgren's Code Posted: 31 Oct 2005 08:06 AM PST What does xlRow = at that time? I just tried it with the Excel 11 (2003) object library and it works fine. I developed it on excel 2000. I suspect you are missing some of the code. Copy and paste the whole thing again. The first 4 lines should be: Option Explicit Dim xlRow As Excel.Range Dim xlCol As Excel.Range Sub TaskHierarchy() If you haven't defined xlRow then you will get an Object required error. You can also get rid of the dwn and rgt functions if you like and just use plain old offset within the code. This example is supposed to demonstrate passing parameters (very simple ones) so that is the reason they are there in the first place. -- -Jack ... For Microsoft Project information and macro examples visit http://masamiki.com/project or http://zo-d.com/blog/index.html .. "scott_hanebutt" <microsoft.com> wrote in message news:com... and 2003, first to cursor at by idea. If problem then message is from visit http://masamiki.com/project/exporthierarchytoexcel.bas. |
Posted: 31 Oct 2005 06:17 AM PST Hi Robert, In that case, try posting on the server newsgroup. Please see FAQ Item: 24. Project Newsgroups. FAQs, companion products and other useful Project information can be seen at this web address: http://project.mvps.org/faqs.htm Mike Glen Project MVP Robert wrote: |
Posted: 31 Oct 2005 05:56 AM PST You're welcome, Jim :-) Mike Glen MS Project MVP Jim Jones wrote: |
How to hide inactive resources Posted: 31 Oct 2005 05:46 AM PST Hi Chris, :) Of course it is. It's always interesting to compare different points of view! Gérard |
zooming in on task pane - not gantt chart Posted: 30 Oct 2005 08:04 PM PST You're welcome, Kimi :-) Mike Glen MS Project MVP Kimi Himi wrote: |
colour code milestones in calendar view? Posted: 30 Oct 2005 06:14 PM PST Benjiluck: You might want to use a custom field (flag/text) to establish the difference in the milestones or you can use a tag. It sounds like a custom field to define the differences would be best route and then you can color code that. "Benjiluck" wrote: |
Constraint - Start no earlier than Posted: 30 Oct 2005 11:21 AM PST >That's very strange behaviour. Are you scheduling tasks to start ASAP? Yes. If I enter a new task, it says âAs Soon As Possible.â Yes Yes. I have several and they are all FS Yes was giving you problems should start on either the first working moment after its predecessor finishes or the constraint date, whichever is later. I dunno. Maybe itâs just me Iâve always found Project to be a little quirky like this. I can usually solve a problem but it seems to invariably involve taking a task out and putting it back in. "Steve House [Project MVP]" wrote: |
Posted: 29 Oct 2005 05:33 AM PDT In article <hip9f.5466$bigpond.net.au>, "Bob Sinclair" <com> wrote: Bob, You're welcome. John |
Work Week MSP98 (Newbie Question) Posted: 29 Oct 2005 05:07 AM PDT Wow - great Mike, thanks for the heads-up. I'll check all these articles over the next couple of days. Appreciate the support ;) -- Kahuna ------------ "Mike Glen" <glenATmvps.org> wrote in message news:phx.gbl... |
Wrap text in Microsoft Project 2000 Posted: 29 Oct 2005 02:27 AM PDT Thanks Rod, When using 'Print preview' on various printers, the problem continues to exist; i.e. the text remains on 01 line when printed but is wrapped in the original doent. It also occurs in a similar fashion when I .pdf the doent. Suggestions ??? Thanks "Rod Gill" wrote: |
Posted: 28 Oct 2005 11:12 AM PDT Also more info on creating your own here: http://zo-d.com/blog/archives/programming.html -- -Jack ... For Microsoft Project information and macro examples visit http://masamiki.com/project or http://zo-d.com/blog/index.html .. "John" <com> wrote in message news:microsoft.com... wondering |
Critical Path - Critical Chain Tracking of Projects Posted: 28 Oct 2005 09:50 AM PDT Stuart, You need to be able to highlight the Resource Critical Path, as explained in Eric Eyttewaal's book, Dynamic Scheduling with MSP 2003. By highlighting the RCP you will be able to keep an eye on tasks that are either driven by logical dependencies (CPM) or by resource dependencies. In his book Eric explains a manual method for highlighting the RCP. As well, a macro is available by license that will do this for you automatically. Yes, this is a feature that should be available in MSP. One of the very big limitations of the CPM is that it does not take resource vailability into account. Charlie Ashmore |
Posted: 28 Oct 2005 07:59 AM PDT That was great. Thanks, it's working fantastic now. "Jan De Messemaeker" wrote: |
Posted: 28 Oct 2005 07:28 AM PDT Thanks. I think we are going to try out the stuff from critical tools. I just wanted to try to make sure I was not missing something in Project. I haven't seen Eric in a while. If he gets back in, I'll say you said HI. jlb "davegb" wrote: |
Posted: 28 Oct 2005 06:58 AM PDT Sorry. The government...espcially the DOD and NOAA are using a busineess process called: Planning, Programming, Budgeting, and Execution Sytem (PPBES). Nothing magic...but it is a well established in the government. It's obviosly cyclic, with no project start or stop date. Thanks/cascott "davegb" wrote: |
Hiding Subproject summary tasks? Posted: 28 Oct 2005 03:33 AM PDT Thanks for that! If I grouped the tasks by 'Project', 'Resource Initials', 'Outline Number'. Can I still 'flag' the summary tasks there? Or is there another way to do it? "davegb" wrote: |
Task splitting - a process, not a parameter? Posted: 28 Oct 2005 02:50 AM PDT Hi George, Split Parts of a task can be read using the SplitParts method. You can read the help through the object browser. To help you onthe way, here is the help on the SplitParts Object (which has a count, a start and a finish property) - go on reading I comment on asignment splist below- SplitPart Object, SplitParts Collection Object Represents a task portion. The SplitPart object is a member of the SplitParts collection. Using the SplitPart Object Use SplitParts(Index), where Index is the task portion index number, to return a single SplitPart object. The following example lists the start and finish times of each task portion of the task in the active cell. Dim Part As Long, Portions As String For Part = 1 To ActiveCell.Task.SplitParts.Count With ActiveCell.Task Portions = Portions & "Task portion " & Part & ": Start on " & _ .SplitParts(Part).Start & ", Finish on " & _ .SplitParts(Part).Finish & vbCrLf End With Next Part MsgBox Portions Using the SplitParts Collection Use the SplitParts property to return a SplitParts collection. The following example returns the number of task portions for each task in the active project. Dim T As Task For Each T In ActiveProject.Tasks If Not (T Is Nothing) Then MsgBox T.Name & ": " & T.SplitParts.Count End If Next T Use the Split method (Task object) to add a SplitPart object to the SplitParts collection. (The Split method creates a split in a task.) The following example creates a split in the task from Wednesday to Monday. ActiveCell.Task.Split "10/1/97", "10/6/97" ------------------------------------------------- There is no method for asignment splist but they can be discovered by looking for zero-work periods using the timescaledata method and the timescalevalues object. Hope this helps, -- Jan De Messemaeker Microsoft Project Most Valuable Professional http://users.online.be/prom-ade/ +32-495-300 620 "G Lykos" <com> schreef in bericht news:phx.gbl... to |
You are subscribed to email updates from TextNData Forums - Microsoft Project To stop receiving these emails, you may unsubscribe now. | Email delivery powered by Google |
Google Inc., 1600 Amphitheatre Parkway, Mountain View, CA 94043, United States |