HowTo: Create new project from existing template and fill in value

[Lidschi]

Hi Newsgroup,

is it possible (and if yes, please tell me how) to create a new project from
an existing template and fill in values from another database?

Thank you in advance for your help.

Greetings
Lidschi.

 

[Gilgamesh]

Hi Newsgroup,

is it possible (and if yes, please tell me how) to create a new project from
an existing template and fill in values from another database?

Thank you in advance for your help.

Hi,
I did this a few years ago so I don't remember the details.
I used a text control file rather than a database and wrote a macro to do
it.
The macro opened the control file and the template. Based on the values in
the control file the macro adjusted the individual resource work values on
selected tasks in the template and then saved the template as a new file.
The control file had quite a few entries so I ended up with approx 100
project files using the smae resources. So I had the macro also create a
resource pool and make sure that the resource levelling would be consistent.
I also had the macro create a master schedule with the 100 odd project files
included as sub-projects.

 

[Lidschi]

Hi Gilgamesh,

thanks for your help so far. Just to get me started: Did you implement the
macros via Visual Basic Code or did you use the recorder.

Greetings
Lidschi.

 

[Gilgamesh]

Hi Gilgamesh,

thanks for your help so far. Just to get me started: Did you implement the
macros via Visual Basic Code or did you use the recorder.

I implemented them via VB code. The recorder can't open text files or do
the needed loops.

 

[Lidschi]

Hi Gilgamesh,

since there is a way to import flat files into the SQL Server database and
generate a new project from this data - isn't that the easier option? Did you
try that option? I am just curious because I don't wanna go into detail if
there is another documented option from Microsoft.
Can you publish the vba code that you mentioned?

Thanks for your help and Greetings
Lidschi.