Manipulating data in Project 2000/2002 .mpp files

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Project
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - How do I set up external dependencies in Project? I am working with master project and sub project. The problem is, how do I set up external dependencies in Project? It works by set up in gantt chart view. But,is there another way to do it more effectively and efficiently? Tag: Manipulating data in Project 2000/2002 .mpp files Tag: 83803
  - 2
    - Additional time zones in Project Is it possible to display more than one time zone in Microsoft Project? We're managing a project with resources in 2 different time zones and it would be easier to be able to show the times of the tasks in each time zone. Tag: Manipulating data in Project 2000/2002 .mpp files Tag: 83798
  - 3
    - How can I show Task Date and Time information I want to show time and date information for one specific mpp file across all the user desktops. How can I set that up? I want to create a view that sequences the tasks by date and time. I can perform options\view on my desktp. How can I set the project file to show date and time information for ALL user? Thanks Harry Tag: Manipulating data in Project 2000/2002 .mpp files Tag: 83796
  - 4
    - Project to Excel Hello, I am new to Microsoft Project and don't know a lot about it. Not eneryone at my company has project on their computer and I need to be able to send programs to them. Is it possible to save the Gnatt bar chart in an Excel format? Regards, Henry Tag: Manipulating data in Project 2000/2002 .mpp files Tag: 83793
  - 5
    - How can I share MS Project 2000 Plan to users who do not have it? I have a project plan prepared in MS Project 2000. I want to share it to my team members who do not have it installed on their machine. How can I share the plan without printing? Tag: Manipulating data in Project 2000/2002 .mpp files Tag: 83787
  - 6
    - How do I show % of where the task SHOULD be? I can show the "status indicator" column which will show me whether a task is on or behind schedule based on my inputs. I'd like to have a column that tells me what percentage each task SHOULD be at at that particular point in time. This will help me to gauge whether the project as a whole is still ahead percentagely, even if some of the tasks are being shown as not started. Thanks, -Kevin. Tag: Manipulating data in Project 2000/2002 .mpp files Tag: 83782
  - 7
    - Getting a Custom Field with a formula to left justify I wrote a formula for a field and it wants to right justify in the tasks table. this makes it very hard to read as none of the items start at the same place or line up. Is there any trick to make a custom field that uses a formula returning a string to left justinfy in the tasks tabel of the gant chart view? Thanks. Tag: Manipulating data in Project 2000/2002 .mpp files Tag: 83781
  - 8
    - Using Resource Pool to see overallocation Hi, I work in a group of planners that use Project pretty extenisively. We have been asked to figure out a way to analyze overallocation across 16 large projects using name based resources. Is it possible to create a common resource pool, use the pool to resource load the 16 schedules and then use the common resource pool to identify where resources are overallocated as a cumulative number. Meaning, many folks are working on 3 or 4 projects at a time and their managers want to know that in 6 months from now are they unknowingly overcommitting themselves on some of these projects. Any help would be much appreciated. Thanks, Steve Tag: Manipulating data in Project 2000/2002 .mpp files Tag: 83780
  - 9
    - Shared Resource Pool Shows deleted tasks Hi, I have set up one Resource pool which is currently being shared by 42 small Projects. These projects all have individual Project files. I also have another project file that provides me with a consolidated view of all 42 projects. My problem is that I recently added the 42nd Project. After I added it to the resource pool and to the consolidated view I renamed and deleted some subtasks. These subtasks no longer show in the individual Project or on the consolidated view. The resource Pool however is another matter. The deleted tasks are still showing up and are still tying up a resource. I have tried disconnecting project 42 from the resource pool but this has had no effect. Any suggestions? Katrina Tag: Manipulating data in Project 2000/2002 .mpp files Tag: 83776
  - 10
    - how do I force a task(eg. a workshop) to begin & end the same day. To any bright MS Project superuser - I have many workshops planned as tasks in a complex project. They run a full day (8 hours) each. As I change or add tasks & Ms Project recalculates my schedule, I need each workshop to begin & end the same day, without having to go through hundreds of lines and manually constraining each one each time. How can I notify MS project that these particular tasks must not be split across 2 days? thanks Tag: Manipulating data in Project 2000/2002 .mpp files Tag: 83774
  - 11
    - How do I export custom MS Project reports into Excel? I've created a custom report in MS project but it only allows me to print the report. I would like to export the data into excel. Can this be done? I'm using Project 2000 currently. Tag: Manipulating data in Project 2000/2002 .mpp files Tag: 83768
  - 12
    - import & update actuals I have a large project and approximately 25 people sending me weekly spreadsheets to update their actual hours worked. Not knowing the havoc that it was going to create, I was importing those spreadsheets into my project plan and updating the actual work column. Everything was working fine until I just discovered that the actuals were updating future date. For example, the plan allocates each resource to work 6.4 hours per day. That's a total of 32 hours per week. If a resource sends in that they worked on a task for 40 hours that week and I increase the actual work column by 40, behind the scenes project only puts 32 hours on the current week and then schedules the rest for the following week. One, I need to figure out how to get all the hours posted from the past 16 weeks to be backdated so there is no longer future dated actuals. And then, two, I need to figure out how to post the actual hours by date instead of just updating the actual work column....or is there a way to tell project to force any overage to the current billing week. Any help or insight would be appreciated. -- Carol Summa Tag: Manipulating data in Project 2000/2002 .mpp files Tag: 83766
  - 13
    - How to link Microsoft Project to outlook for task reminders? I would like to be able to have a reminder pop up similar to outlook in my Project Software. Tag: Manipulating data in Project 2000/2002 .mpp files Tag: 83760
  - 14
    - Project Pro 2002 Print Preview Crash I am currently working with a Project Pro 2002 file that contains 1000+ tasks that is having a problem with print previewing and printing the Gantt Chart when I have a Progress Line showing on the chart. When I autofilter on a Contact field to certain names, the program crashes and requires a restart of Project. It shows fine for some and others cause it to crash. Not sure what to do. -- Randy Rettinger Tag: Manipulating data in Project 2000/2002 .mpp files Tag: 83757
  - 15
    - how do I verify msn messenger e-mail address, step by step please I have windows xp, i'v downloaded msn messenger, I haven't been able to verify msn messenger e-mail for outlook express. I't tells me to go to .netpassport e-mail in box, open passport message but i can't or don't know how to get there to proceed with verification in order to use mns messages. I need step by step instructions on how to do this. Please help Tag: Manipulating data in Project 2000/2002 .mpp files Tag: 83755
  - 16
    - concurrent projects on the same calendar I am using Project to manage the building schedule for the local Habitat for Humanity. The same homebuilding tasks are accomplished in the same order in one home after another, but the starts are staggered. Sometimes the duration of tasks change, but never the tasks themselves. Is there a way to show the progress of several different homes on the same calendar? For example I'd like to have a calendar showing that on August 1st, there will be painting in home #1, hanging drywall in home #2, and raising walls in home #3. Tag: Manipulating data in Project 2000/2002 .mpp files Tag: 83745
  - 17
    - How do I sort by date and Time I want to sequence tasks by date and time in ascending order and create a view of the project plan file. Any ideas to accomplish this easily. Thanks. Harry Tag: Manipulating data in Project 2000/2002 .mpp files Tag: 83738
  - 18
    - file number changes to ~1.MPP after routing Hello, I have a template using MS project 2000. We save the template for .i.e. 3999 ver 0.2 and route it to other team memebrs. Often after routing, the file name changes to 3999~1.MPP so ver 0.2 chnages to ~1 Would you please advice I wish I could send you electronic file which is a small file. Thank you Majid Tag: Manipulating data in Project 2000/2002 .mpp files Tag: 83736
  - 19
    - How to create a 7-day work week? This is a multi-part message in MIME format. ------=_NextPart_000_0008_01C5561B.C775F7B0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I need to create projects with a 7-day work week by default. I am = entering a 3 day task which starts on Thursday and should end on = Saturday. Instead, Project draws the task from Thurs to Monday. I have = gone to the Change Working Time dialog to change individual weekend days = to working days but is ridiculous to do over a multi-month project. How can I make every day a working day? Thanks, Curtis ------=_NextPart_000_0008_01C5561B.C775F7B0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 6.00.2900.2627" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT face=3DArial size=3D2>I need to create projects with a 7-day = work week by=20 default. I am entering a 3 day task which starts on Thursday and should = end on=20 Saturday. Instead, Project draws the task from Thurs to Monday. I have = gone to=20 the Change Working Time dialog to change individual weekend days to = working days=20 but is ridiculous to do over a multi-month project.</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>How can I make every day a working=20 day?</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Thanks,</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Curtis</FONT></DIV></BODY></HTML> ------=_NextPart_000_0008_01C5561B.C775F7B0-- Tag: Manipulating data in Project 2000/2002 .mpp files Tag: 83731
  - 20
    - Summary task Resources Hi, Is there a way to have MSP calculate the resources usage of a resource for a summary task based on the detailed of the sumamry ? I would like to be able to see the resource graph (Split window) for a summary so I will have the allocation for the each resource linked to that sumamry task without going in more details. I guess MSP should calculate the resources and their allocation for a summary but not to imputate the cost (double counting) but that is not hapenning on my case. Maybe there is a screen I do not know about. Thanks, Nde Tag: Manipulating data in Project 2000/2002 .mpp files Tag: 83730
  - 21
    - copying a full project plan into another programme I want to copy my project plan into MS Word for distribution to other members of the team who do not have MS Project, but currently can only "screen dump" into these. Obviously the Project plan is 4 pages long and I want all the four pages to show up. Does anyone know how to do this? Thanks Tag: Manipulating data in Project 2000/2002 .mpp files Tag: 83729
  - 22
    - Fields available in microsoft project Hi, Anybody know where I can find a list of all fields available in Microsoft Project Pro 2003? Mario Tag: Manipulating data in Project 2000/2002 .mpp files Tag: 83726
  - 23
    - Microsoft calender keeps dropping important items on staff calenda Our church staff uses Microsoft calendar to keep important dates, i.e. weddings, baptisms, vacations, etc. and from time to time is drops a vacation, or wedding. Are we doing something wrong, are we putting too many things on the calendar? Is there another program that you can recommend we can use so I won't have heart failure because a wedding has dissappeared? Thank You Tag: Manipulating data in Project 2000/2002 .mpp files Tag: 83725
  - 24
    - Error I have just upgraded from project 98 to 2000 when I start up project or open a project file it keeps coming up with 'Microsoft Visual Basic' Errors occured during load. Any ideas? I know nothing about project! Tag: Manipulating data in Project 2000/2002 .mpp files Tag: 83724
  - 25
    - Can you change Projects page numbering when printing? When printing from MS Project 2003 the first page is numbered 0. Can that be changed to 1? Tag: Manipulating data in Project 2000/2002 .mpp files Tag: 83723
- Next
  - 1
    - Rescheduling uncompleted work Greetings. I'm developing a prototype for the production planning of a small factory. We've decided for a master project with a number of subprojects (one for each order). The resource pool is on the master project. Every day, the planner needs to update the completed tasks and reschedulle those that didn't start when they should have. Tried to reschedulle, in the master project, for all the subprojects but it didn't work. I need to open each of the subprojects and reschedulle one by one. As each subproject is relatively short (a couple of days) and it may add up to 100 simultaneous sub-projects, reschedulling one by one will consume too much time to be practical. Is there any way to reschedulle the uncompleted work for all the subprojects, no matter how many they are, with only a few steps? Thank you for your help, Joaquim Amado Lopes Tag: Manipulating data in Project 2000/2002 .mpp files Tag: 83722
  - 2
    - problem loading Workgroup Mail feature in project 2003 professiona I want to use MS Project to send e-mails to resources so they can be aware of tasks, and update their status. I understand Workgroup mail should help me with this. I have downloaded the files from the MS site and installed them & updated my registry but still can't see the tool in my tools option. Help Tag: Manipulating data in Project 2000/2002 .mpp files Tag: 83714
  - 3
    - About error in enterprise resource pool Hi, due to some problem I have deleted windows account from msp_resources and msp_web_resources tables but when i want to add the windows user account in the enterprise resource and save that resource. pool it will create an error " Duplicate windows Account" I dont know how i can solve this problem . pls help me regards micheal Tag: Manipulating data in Project 2000/2002 .mpp files Tag: 83704
  - 4
    - Start-to-Finish dependency between summary task & predecessor Hello, I am trying to shedule a summary task (ST1) to start so that it finishes at the same time that a sub-task under another summary task (ST2) begins. ST2 lasts 8 weeks and ST1 lasts 3 weeks, the sub-task under ST2 begins 6 weeks into it. So, I want ST1 to start 3 weeks into ST2. With me so far?!? Project won't let me assign a 'Start-to-Finish' dependency between the sub-task and ST1 so I am forced to use a 'Start-to-Start' dependency with a 3 week time lag. Obviously this is not ideal, as any change to ST1's duration will not change its start date - to do this requires me to manually change the time lag to equal the duration of ST1. If anyone can understand this and help me I would be very grateful, Henry Tag: Manipulating data in Project 2000/2002 .mpp files Tag: 83700
  - 5
    - Administrative & Master Project Dear Friends, I inserted 3 projects to the administrative project then i published it to the Project Server.When i open the Administrative Project from the PWA i can see ONLY the name of the inserted Projects! I actually dont see the tasks details for the inserted projects! This scenario happens also in Mster Projetcs! Dears, is there any solution to display the tasks of inserted projects of administartive project whithin PWA ? Thanks in Advance. :) -- PMO Specialist Tag: Manipulating data in Project 2000/2002 .mpp files Tag: 83696
  - 6
    - Change Working Time Would anyone know how to set up a project as a 13 day fortnight? This is particularly helpful with our roster at the moment Tag: Manipulating data in Project 2000/2002 .mpp files Tag: 83693
  - 7
    - Unallocated Resource I'm new to project and I was wondering if it is possible to indicate the number of mandays per week required from a specific resource type for the duration of the project where the resource remains unallocated (i.e. where resource is not available). I'm using Project 2003 Thanks Tag: Manipulating data in Project 2000/2002 .mpp files Tag: 83692
  - 8
    - Archiving Information Is it possible to archive so that previous weeks actual resourcing figures are stored against each project and become read-only. I'm using Project 2003. Thanks Tag: Manipulating data in Project 2000/2002 .mpp files Tag: 83691
  - 9
    - re-priorities existing projects In Project 2003 am I able to add new projects or re-prioritise existing projects in the workstack whilst retaining all associated resourcing actuals & forecasts. Tag: Manipulating data in Project 2000/2002 .mpp files Tag: 83690
  - 10
    - Log on to MSP brings up security logon screen My current client has difficulties for all their resources to log onto MSP. If they select "Connect" on Project Server Accounts, the Project Server Security Logon screen appears and they have to say cancel once and again "Connect" before it connects to the project server. Is there any solution for this problem? Tag: Manipulating data in Project 2000/2002 .mpp files Tag: 83679
  - 11
    - Resource Usage view accross all projects for enterprise resources When looking at the resource usage view, you see all projects resources are assigned to.This is very helpful for overallocation on all projects.But the problem is seeing specific info per project, eg specific allocation per project and also costs.It's easy enough to filter per project name and only see your active project's tasks, but the cost for example does not calculate correctly to summary level, it still displays the total across all projects. Is there any other way to only see resource assignments for your active project? Tag: Manipulating data in Project 2000/2002 .mpp files Tag: 83678
  - 12
    - Actuals entered by resources moves out finish date of task When a resource updates actuals in an external timesheet (PWA or internal timesheet system), and the actual start date is moved forward as it should to the first date the resource has booked time on, the remaining work is scheduled inconsistently with weird work values such as 0.18 per day for more than 15 days, where the resource was initially scheduled for only 3 days at a 100%. Please assist. Tag: Manipulating data in Project 2000/2002 .mpp files Tag: 83677
  - 13
    - Program Project and subproject Dear Friends, I have a program project named SSP and it has 10 subprojects. I want the Program Manager to see the name of the Program project (SSP) its subprojects as the follwing un the PWA: -SSP Proj.1 Proj.2 Proj.3 Proj.4 Dears , Is there any way to do the scenario? Can any body give a solution in details? Thanks in Advance. -- PMO Specialist Tag: Manipulating data in Project 2000/2002 .mpp files Tag: 83676
  - 14
    - Who Does What Report displaying the parent task Hi Guys, I'm after a "Who does what report" or any report that also displays the parent task it belongs to. Is there any way of getting a report out like this? We have sub tasks assigned to resources such as Complete Change Control or Purchase Equipment and when I try to do any sort of reporting Project only lists the sub tasks, so as you can imagine it makes it diffucult as the resource doesn't know what the Change Control Form is for or what they are purchasing equipment for. Tag: Manipulating data in Project 2000/2002 .mpp files Tag: 83672
  - 15
    - Correct Duration I have a "task" which is represented by a ship sailing from port a to port b. It will leave port a on 19/5/5. The voyage is 30 days. I would like Project to display the length of the task "correctly". I have entered duration in project as 30 days. The task will take exactly 30 days it is not effort driven and the ship will not arrive early or late. I have assumed the task will run every hour of the day since the ship is always working as it is sailing from a to b. I have tried to use various settings in the calanders available in project but cannot get it to display the proper end date - which is 30 "real" calander days after 19/5/5. Project seems to grossly over estimate the end date. Any help on how to get the correct end date would be appreciated. Tag: Manipulating data in Project 2000/2002 .mpp files Tag: 83667
  - 16
    - help with font size on task notes Can someone please help me? I'm trying to change the font size for the headers in the task notes. The font size is currently set at about 8 points and I can't seem to change this. I can change the size of the tasks notes themselves. However, I can't figure the size of the headers (task name) that print off with the notes. Thanks! -Doug Tag: Manipulating data in Project 2000/2002 .mpp files Tag: 83661
  - 17
    - Reset Priority? Is there a way to reset priorities back to all tasks being 500? OR Is there a way to easily find which tasks has priorities on them? Thanks, regattagirl Tag: Manipulating data in Project 2000/2002 .mpp files Tag: 83659
  - 18
    - Booking type - Task & Resource Hi, I finally found how to define the booking type for a resource. Though it appears that the resource is being flag as proposed through the entire project. The situation is the following : I do have a resource that is committed to certain tasks in the projects, but it is not clear yet if this resource will be available to perform that task. I would like to set that resource as proposed for specific task and comitted to others. The purpose of that is to be able to identify if teh resource is really overallocated or if this is due to propsed allocation. Any idea ? Nde Tag: Manipulating data in Project 2000/2002 .mpp files Tag: 83658
  - 19
    - Tracking a project by hours and days. Hello, A brief description of the project. The project that I am working on is quite basic but causing me grief. My project consists of approx. 10 tasks all starting on the same day, and finishing on the same day. Some resources may be assigned to one or more tasks. The duration of tasks can range from 30 minutes to usually not more than 5 days. First of all our work day is 8:30 - 4:30, 1 hr for lunch. I thought that I had changed the calendar to be 8:30 to 4:30, but the Gnatt chart is still starting at 8:00 am. We also work a 7 hour day and a 35 hour week. It seems that the best way to tract this project on the Gnatt chart is to use the timescale by hours. If I use the timescale by days the task bar for a 30 minute task is very small. I also am having some difficulty when I set the % complete on a task to 50%, it basically runs across the entire bar, not just halfway through. Microsoft Project 2003 I hope that you can help me. Thank you very much. -- Deb Tag: Manipulating data in Project 2000/2002 .mpp files Tag: 83657
  - 20
    - Create and change calendar on an existing project? Hello, Can I create a new calendar and change the calendar on an existing project? -- Deb Tag: Manipulating data in Project 2000/2002 .mpp files Tag: 83656
  - 21
    - Displaying durations to 3 decimal places I am using Project 2000 to create a very precise timing diagram for a complex diagnostic analyzer we are designing. I need to be able to break the machine's individual tasks down into durations that can be expressed in multiples of 0.025 sec increments (our computer scheduler's resolution limit). I am currently letting 1 hr = 1 sec in the duration field for a task, but I can only get the display to show 2 decimal places. I want to be able to input durations and have MS Project work to 3 decimal places, but I don't know if that is possible without customization of the program. For that matter, can Project even be customized in this way if desired ? -- Mech. Engr Tag: Manipulating data in Project 2000/2002 .mpp files Tag: 83652
  - 22
    - MS Project Start Finish times Hello, I am creating a "Micro" plan and I need to change the start and finish from displaying dates to display the hours of the day. Example: task: registration /dur: 30 mins /start 8:30 finish 9:00 Instead of task: registration /dur: 30 mins /start 10/05/05 finish 10/05/05 I hope it makes sence. Thank you George Tag: Manipulating data in Project 2000/2002 .mpp files Tag: 83647
  - 23
    - Project VB Help problem I have done both standard and custom install of MSProj 2000 with similar results - VB Help Answer Wizard and index functions do not work. Help contents can be expanded and browsed, but Answer Wizard and Index fields will not accept focus - cursor takes shape of double-headed arrow but does not permit entering data in keywords fields. Does anybody know what is causing this? Browsing help to find answers is not very helpful. Thanks Dave Tag: Manipulating data in Project 2000/2002 .mpp files Tag: 83646
  - 24
    - Behavior of future tasks that are complete I always do a search before posting so please forgive me if this has already been addressed. Of course a plan is great but life doesn't always follow the plan (I have automatically level resources turned on). So.....how do I handle a task that is 2 weeks out (for example) and now the resource says that it is 100% complete. Thanks, regattagirl Tag: Manipulating data in Project 2000/2002 .mpp files Tag: 83642
  - 25
    - Using ProjectAfterSave Hi all, I have the following macro and it works great, but I would like it to happen automatically every time a project is saved. Can someone help me?! Thanks, Tyler Sub Save_To_HTML() ' Macro Save_To_HTML ' Macro Recorded Wed 4/27/05 by Tyler Johnston. MapEdit Name:="Map 2", Create:=True, OverwriteExisting:=True, DataCategory:=0, CategoryEnabled:=True, TableName:="Tasks", FieldName:="ID", ExternalFieldName:="ID", ExportFilter:="All Tasks", ImportMethod:=0, HeaderRow:=True, AssignmentData:=False, TextDelimiter:=Chr$(9), TextFileOrigin:=0, UseHtmlTemplate:=True, TemplateFile:="\\path\Columns Navy.html", IncludeImage:=False MapEdit Name:="Map 2", DataCategory:=0, FieldName:="Name", ExternalFieldName:="Task Name" MapEdit Name:="Map 2", DataCategory:=0, FieldName:="Duration", ExternalFieldName:="Duration" MapEdit Name:="Map 2", DataCategory:=0, FieldName:="Start", ExternalFieldName:="Start" MapEdit Name:="Map 2", DataCategory:=0, FieldName:="Finish", ExternalFieldName:="Finish" MapEdit Name:="Map 2", DataCategory:=0, FieldName:="Resource Names", ExternalFieldName:="Resource Names" MapEdit Name:="Map 2", DataCategory:=0, FieldName:="% Complete", ExternalFieldName:="% Complete" MapEdit Name:="Map 2", DataCategory:=1, CategoryEnabled:=True, TableName:="Resources", FieldName:="ID", ExternalFieldName:="ID", ExportFilter:="All Resources", ImportMethod:=0 MapEdit Name:="Map 2", DataCategory:=1, FieldName:="Name", ExternalFieldName:="Name" MapEdit Name:="Map 2", DataCategory:=1, FieldName:="Group", ExternalFieldName:="Group" MapEdit Name:="Map 2", DataCategory:=1, FieldName:="Max Units", ExternalFieldName:="Max Units" MapEdit Name:="Map 2", DataCategory:=1, FieldName:="Peak", ExternalFieldName:="Peak Units" MapEdit Name:="Map 2", DataCategory:=2, CategoryEnabled:=True, TableName:="Assignments", FieldName:="Task ID", ExternalFieldName:="Task ID", ImportMethod:=0 MapEdit Name:="Map 2", DataCategory:=2, FieldName:="Task Name", ExternalFieldName:="Task Name" MapEdit Name:="Map 2", DataCategory:=2, FieldName:="Resource Name", ExternalFieldName:="Resource Name" MapEdit Name:="Map 2", DataCategory:=2, FieldName:="Work", ExternalFieldName:="Work" MapEdit Name:="Map 2", DataCategory:=2, FieldName:="Start", ExternalFieldName:="Start" MapEdit Name:="Map 2", DataCategory:=2, FieldName:="Finish", ExternalFieldName:="Finish" MapEdit Name:="Map 2", DataCategory:=2, FieldName:="% Work Complete", ExternalFieldName:="% Work Complete" FileSaveAs Name:="\\path\" & ActiveProject.Author, FormatID:="MSProject.html", map:="Map 2" End Sub Tag: Manipulating data in Project 2000/2002 .mpp files Tag: 83641

Hello all,

This is my first post and I am trying to find out if it is possible to
change data in Project mpp files programmatically from another application?
Also if I change task data do the changes propagate through the project for
related tasks as they would if the data was changed from with in Project?

Any suggestions would be helpful.

Re: Manipulating data in Project 2000/2002 .mpp files by Jan

Jan
Thu May 12 10:40:29 CDT 2005

Hi,

VBA allows you to access all Project objects.
You will have to crerate the MS project application as an object. From there
on you access everything you need.
And of course, changed data propagate just the way hand-changed data do.
HTH

--
Jan De Messemaeker
Microsoft Project MVP
+32 495 300 620
http://users.online.be/prom-ade
"Da. Brown" <Da. Brown@discussions.microsoft.com> wrote in message
news:707FFC18-3477-46FA-A0B6-E0109C2D2C6D@microsoft.com...
> Hello all,
>
> This is my first post and I am trying to find out if it is possible to
> change data in Project mpp files programmatically from another
> application?
> Also if I change task data do the changes propagate through the project
> for
> related tasks as they would if the data was changed from with in Project?
>
> Any suggestions would be helpful.

Re: Manipulating data in Project 2000/2002 .mpp files by Da

Da
Thu May 12 12:34:01 CDT 2005

Thanks

"Jan De Messemaeker" wrote:

> Hi,
>
> VBA allows you to access all Project objects.
> You will have to crerate the MS project application as an object. From there
> on you access everything you need.
> And of course, changed data propagate just the way hand-changed data do.
> HTH
>
> --
> Jan De Messemaeker
> Microsoft Project MVP
> +32 495 300 620
> http://users.online.be/prom-ade
> "Da. Brown" <Da. Brown@discussions.microsoft.com> wrote in message
> news:707FFC18-3477-46FA-A0B6-E0109C2D2C6D@microsoft.com...
> > Hello all,
> >
> > This is my first post and I am trying to find out if it is possible to
> > change data in Project mpp files programmatically from another
> > application?
> > Also if I change task data do the changes propagate through the project
> > for
> > related tasks as they would if the data was changed from with in Project?
> >
> > Any suggestions would be helpful.
>
>
>