Importing custom fields to multiple projects. RRS feed

  • Question

  • Hi all,

    i have 35 schedules, all of which are linked to a resource pool.

    I have manually imported 2 custom fields into them. The custom fields are text fields, each with a lookup table. The problem is that one of the lookup tables is receiving regular updates, meaning i have to reimport the field on each update. Is there a quick way to import this lookup table to multiple projects?

    Note, i originally asked this question in the wrong forum, apologies mods (are there any mods??)

    Tuesday, March 5, 2013 10:44 AM

All replies

  • You were probably on the right forum the first time, as you're probably going to need some VBA customisation, but not to worry, as it's largely the same people on both.

    The best solution I can think of is to create a master project with all 35 sub projects inserted within it. You could then have a VBA routine which stepped through each project in turn updating the look-up field definitions for you. Best bet would be to schedule it to run overnight when none of the 35 should be locked out for editing.

    If this sounds workable, let me know and I can provide more detail.


    Tuesday, March 5, 2013 10:51 AM