Consulting

Results 1 to 2 of 2

Thread: Solved: Copying Custom Column/Fields to SubProjects

  1. #1

    Solved: Copying Custom Column/Fields to SubProjects

    I have three columns with customized lists for input and need to copy them to about 600 files. I wanted to know how to "walk the files" from one main file and copy the columns into each subproject file. Thanks

  2. #2
    got it. Thanks anyway.
    [VBA]Public Sub AddCustomInfo()
    Dim proj As Project
    Dim Path As String
    Dim SP As Subproject
    Application.DisplayAlerts = False
    Set proj = ActiveProject
    For Each SP In proj.Subprojects
    Path = SP.Path
    FileOpen Name:=Path, ReadOnly:=False
    Call WhateverMacro(ActiveProject) 'adjust this to be whatever you want added
    FileClose pjSave
    Next
    End Sub[/VBA]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •