Re: Linking Problem in MS PRoject

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Rod Gill (rodsngtrap_at_hotmail.com)
Date: 11/11/04 

Date: Fri, 12 Nov 2004 10:26:59 +1300

You've hit the limits of an old technology that does the linking. It sounds
like you need some VBA code to automate this process or:

Set Flag1 to Yes for all tasks you want to have in the new plan. Create a
new master (but don't link). This creates a copy of all tasks.
Create a filter called Flag1 that only shows tasks with all flags set to
Yes.
A simple recorded macro can make creating the new master very quick and
easy. Save the new master each week as a historical record of schedule
progress. 

-- 
For VBA posts, please use the public.project.developer group.
For any version of Project use public.project
For any version of Project Server use public. project.server
Rod Gill
Project MVP
For Microsoft Project companion projects, best practices and Project VBA 
development services
visit www.project-systems.co.nz/
Email rodg AT project-systems DOT co DOT nz
"Rambo" <Rambo@discussions.microsoft.com> wrote in message 
news:CAFBE07C-B5F5-4854-AF92-6EBAE0265ECD@microsoft.com...
> We are using a master.mpp file for a project and extracting selected tasks
> line items for another file to which we are adding more detail to.  We do 
> not
> want to affect the master file so we can't use bidirectional linking. 
> What
> we did do was create an excel spreadsheat and paste linked the entire 
> master
> into the spreadsheet.  From there we created the detailed file by paste
> linking to the cells in the spreadsheet.
>
> Here's the problem.  When someone adds a new task to the master.mpp file
> everything updates properly.  However, when a task in the master.mpp file 
> is
> deleted, the paste linked items in the detailed file are shifted off their
> original location by one task line item which corrupts all the linked 
> dates
> and data.
>
> How can we extract data from a master project into a another project 
> without
> affecting the master project (no shadow linked tasks)?

Relevant Pages

  • Re: Macro
    ... Then I have a macro that uses a VBA macro and oledb to read all summary data ... For VBA posts, ... I right now have a Master Consolidated file ... I appreciate your reply very much John, ...
    (microsoft.public.project)
  • Re: Resource Usage view
    ... the Project field in the master will display only the subproject file ... With regard to the VBA approach I don't understand your statement about ... a custom install and specifically excludes VBA functionality. ... path in the Project field on the assignment rows of the Resource Usage ...
    (microsoft.public.project)
  • Re: Task ID assignment for external dependencies
    ... I have been using the linking file technique with good effect since Project ... Back in 1999 I did try to run the links through the master with poor ... links so they have a consistent UniqueID sequence, ... When things work as I expect, the ghost task for the external predecessor ...
    (microsoft.public.project)
  • RE: Consolidate multiple workbooks (...and adding new files in the mas
    ... This is not that difficult to do with VBA, ... one workbook and adding additional files in the master workbook on the ... My excel wizard colleague tells me that this isn't possible in excel, ...
    (microsoft.public.excel.misc)
  • Re: Task ID assignment for external dependencies
    ... I have been using the linking file technique with good effect since Project ... Back in 1999 I did try to run the links through the master with poor ... the ghost tasks appear next to the ...
    (microsoft.public.project)