I am about to create a master plan that will contain over 200 small sub project files. Each sub project file will have common elements such as standard Custom fields.
I have created a template for the sub projects and will now replicate it for each of the 200+ projects and them distribute them to the relevant Project Managers. My worry is that after creating these 200+ project files I will realise I need to make an identical change to all of them. EG Add a new custom field to each file, or modify a drop down list in each file, or add a new filter to each file.
Is there a way, presumably using VBA, that will allow me to apply the change to all the sub project files via one instruction? EG if I want to show custom field Date1 (renamed to TargetDate) in each sub project file, what is the best way to do this other than modifying each file manually one after the other?