Automatic date change after a value has exceeded a certain point

[laruvv]

I have a mpp which has a link to excelfile.
I need project to change the date (to next day) after the sum of linked
excel cells exceed 60?

Is there a way to do this in project?
Thanks in advance
Laura

 

[Jan De Messemaeker]

Hi Laura,

"The Date" is a somewhat simplistic expression when talking about Project,
each task has at least 70 properties that are dates!

So, it all depends.
If you talk about a custom field (one that has a name ending on a numeric
such as Date7), it can be done because these fields can contain a formula;
so you could put an OLE link from the excel value (only one, but you could
make the sum with an Excel formula in Excel) to a Number fielsd in Project
and put the appropriate formula in the date field.

But I'm afraid you talk about a date field that Project uses for its
calculations such as Start or Finish... in that case it can only be done
through automation for instanc a VBA procedure.

Hope this helps,

 

[laruvv]

Thanks.
SO it'll have to be with vba.
Laura

Hi Laura,

"The Date" is a somewhat simplistic expression when talking about Project,
each task has at least 70 properties that are dates!

So, it all depends.
If you talk about a custom field (one that has a name ending on a numeric
such as Date7), it can be done because these fields can contain a formula;
so you could put an OLE link from the excel value (only one, but you could
make the sum with an Excel formula in Excel) to a Number fielsd in Project
and put the appropriate formula in the date field.

But I'm afraid you talk about a date field that Project uses for its
calculations such as Start or Finish... in that case it can only be done
through automation for instanc a VBA procedure.

Hope this helps,

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/
+32-495-300 620