VBA to use all projects in folder as subprojects

[SamT]

I suspect that this is not consolidating to the project you think it is

ConsolidateProjects Filenames:=projFile, NewWindow:=False, HideSubtasks:=True 
        SelectTaskField Row:=1, Column:="Name"

Ii is not consolidating TO a specific project. ConsolidateProjects is a method. without an Object being specified, it is probably being applied to the Application Object.

This consolidates TO the Master.cpp Project (See Post #6)

MasterProject.ConsolidateProjects(Filenames:=projFile)

The object here is the specific Project Object.

Record these two macros and share the results with me.

1. In Project, open the files that you want to consolidate
2. On the Window menu, click New Window.
3. In the Projects list, click the file that you want to list first when you combine the projects.
4. To select adjacent projects, hold down SHIFT, and then click the first and last project that you want to list in the consolidated project. To select nonadjacent projects, hold down CTRL, and then click the name of the next file that you want to list in the consolidated project.
5. Repeat this step until you have selected all the files that you want to consolidate.

On the Insert menu, click Project. Select the files that you want to consolidate, and then click Insert.

See Also:
http://www.epmcentral.com/articles/p...terproject.php
http://www.mpug.com/articles/ask-the...ross-projects/