VBA Macro Code Error (Gerard) Microsoft Project |
- VBA Macro Code Error (Gerard)
- Household project management software
- Protection
- SPI in Project 2000
- Row Numbering
- Earned value Calculation
- Shading Columns
- Critical path calculations
- Accrual of costs
- Multiple Resource Pools
- Outlook Add-in for Project Web Access not loading... help
- Disable Task Information
- Calendar Changes
- Customise the Timescale
| Posted: 23 Apr 2004 01:36 AM PDT You test on "nothing" tasks, what about "summary" or "external" -- __________________________________________________ _______ Mark Durrenberger, PMP Principal, Oak Associates, Inc, www.oakinc.com "Advancing the Theory and Practice of Project Management" __________________________________________________ ______ The nicest thing about NOT planning is that failure comes as a complete surprise and is not preceded by a period of worry and depression. - Sir John Harvey-Jones "Verossa" <microsoft.com> wrote in message news:com... MS Excel and am recieving the following error: Len(oTache.Parent.Name) - 4) Len(oTache.Parent.Parent.Name) - 4) |
| Household project management software Posted: 22 Apr 2004 11:21 PM PDT This might be what you're looking for http://ganttproject.sourceforge.net |
| Posted: 22 Apr 2004 12:33 PM PDT Thanks John. I will play with this and see if it will be useful for me. Cheryl from "tampering" but that duplicate fields out of any be used to see if any fact you are using Versions" add-in do the macro that could up an event If a change is |
| Posted: 22 Apr 2004 12:16 PM PDT Stevie, I think I did. You need to enter the formula correctly - exactly like this: [BCWS]/[BCWP] in a spare user defined field. Step by step: From insert menu select column pick the text10 field (if it is not already used) click OK Now rightclick on the text10 column header select customize fields click on the "formula" button enter the formula above At this point you can rename the field to SPI or do other things. click OK. -Jack "Stevie" <com> wrote in message news:google.com... news:<phx.gbl>... already |
| Posted: 22 Apr 2004 11:21 AM PDT Aarti, Three other suggestions beyond what Andrew offered. First, check to see if the tasks are sorted by something other than task ID. Second, if the file is a master file with inserted subprojects, try opening the subprojects and then use the "Show subtasks". Third, if the file has external links to another file, check the setting of Tools/Options/View tab and ensure that the two check boxes for external predecessors and successors is checked. Hope this helps. John |
| Posted: 22 Apr 2004 08:06 AM PDT Thanks to all that replied. I had tried to re-enter all the actuals as Gerard has suggested by redoing the plan, but that did not work. Finally I figured it out. I had to change some options under the calculation tab. 1. Actuals costs are always calculate by Microsoft Projec 2. Uncheck Move End of.... and Move start of..... 3. Default Fixed Cost acruals ---> "Prorated" instead of "End I changed all these and it started working. Thanks to all. |
| Posted: 22 Apr 2004 06:45 AM PDT You can't shade columns but you can change text color/style. I've set up a bunch of tables. Calculated columns are in blue text/italic and user entry columns are black normal - you can also change fonts /bold/underline etc... Mark Here is a screenshot: www.durrenberger.com/screenshot.jpg -- __________________________________________________ _______ Mark Durrenberger, PMP Principal, Oak Associates, Inc, www.oakinc.com "Advancing the Theory and Practice of Project Management" __________________________________________________ ______ The nicest thing about NOT planning is that failure comes as a complete surprise and is not preceded by a period of worry and depression. - Sir John Harvey-Jones "caveman" <microsoft.com> wrote in message news:com... alternating columns to allow a user to be able to differentiate between columns. |
| Posted: 21 Apr 2004 02:06 PM PDT I concur. No reason not to do this. -Jack "Steve House" <send.hotmail.com> wrote in message news:OwY$phx.gbl... |
| Posted: 21 Apr 2004 01:51 PM PDT IMHO, task costs are not showing when PAYMENT is made, they show when the liability is posted into the project budget. How does your 50/50 rule function when you pay 50% of 100 man-hours at the start, work 50 hours, and find that you are going to need 200 hours more to finish for a total actual cost of 250 man-hours. The primary purpose of the cost data is to provide budget estimates, cash flow requirement projections, and monitor project progress metrics - it is not a client time and billing application nor a accounts payable and receivables or revenue tracking. It doesn't deal at all with when costs are paid, only when the work that they're buying is required to be accomplished. -- Steve House MS Project MVP Visit http://www.mvps.org/project/faqs.htm for the FAQs "David" <microsoft.com> wrote in message news:25fd01c427e2$73795480$gbl... |
| Posted: 21 Apr 2004 12:02 PM PDT I would put all the resources into one Resource Pool. You can use Resource Groups to identify the different departments Hope this is helpful --Conra ----- Cheryl wrote: ---- I am using MS Proj. 2002 Standard. I have created resource pools for all sections in our development facility. I have a master schedule comprised of about 50 sub projects. My question is can I incorporate more than one resource pool per project? Such as Res_Pool_ Res_Pool_ Res_Pool_ Res_Pool_ Res_Pool_ Project Project Project Project Project Can Project 1 use resources from Res_Pool_A, Res_Pool_B, and Res_Pool_E All Suggestions welcome Cheers Chery |
| Outlook Add-in for Project Web Access not loading... help Posted: 21 Apr 2004 05:14 AM PDT Eranga: I'm not certain this will work, but try removing the Com Addin from Outlook and reinstalling it. -- Gary Chefetz [MVP] http://www.msprojectexperts.com We wrote the book on Project Server "Eranga Udesh" <com> wrote in message news:phx.gbl... doesn't why |
| Posted: 21 Apr 2004 02:39 AM PDT Why in the world do you want to cripple your PM's? Why give them a tool and then prevent them from using part of it? -- Steve House MS Project MVP Visit http://www.mvps.org/project/faqs.htm for the FAQs "Itzik" <microsoft.com> wrote in message news:20ec01c42784$98d8fc20$gbl... |
| Posted: 21 Apr 2004 01:38 AM PDT Good Morning I agree, and when I realised invoice periods were involved I pointed this out. I think billing periods have just become standard calendar type, partially reflecting the influence of the finance group in every aspect of this organisation Have a good day Ver |
| Posted: 21 Apr 2004 12:51 AM PDT You're welcome as usual, Vers :-) Mike Glen MS Project MVP Verossa wrote: |
| 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., 20 West Kinzie, Chicago IL USA 60610 | |
