Displaying Days between Start of a Task and its Predecessors

[TESA0_4]

I have some VBA knowledge but know zip about MS Project. I'm using Project to
display an aircraft servicing schedule prepared in Excel. The need is to
display in a 'Text' or 'Number' column in Project the number of days between
the planned start of a servicing and the planned finish date of its (single)
predecessor. I can't figure out how to give a variable defined as a task the
value it needs to get the finish date of the predecessor task.
I'm sure this is a dead-simple question for even a Project novice so I hope
someone can help.
Thanks for any help that you can offer.

 

[TESA0_4]

On another thread I found a link to http://masamiki.com/project and one of
the examples there caused me to recognise the subtle difference between
defining a variable as a 'Task' or as a 'Tasks'.
So I have found the answer to my basic question.
If you can tell me the syntax to round the number I have displaying in the
Text2 field to no decimal places that would be helpful!!

 

[John]

On another thread I found a link to http://masamiki.com/project and one of
the examples there caused me to recognise the subtle difference between
defining a variable as a 'Task' or as a 'Tasks'.
So I have found the answer to my basic question.
If you can tell me the syntax to round the number I have displaying in the
Text2 field to no decimal places that would be helpful!!

TESA0_4,
Try the Round Function. Its syntax is:
Round(expression[,number of decimal places])

You can read more about its syntax in the VBA help file.

By the way, "Tasks" is a collection of objects, and "Task" is an element
of that collection.
John
Project MVP

 

[TESA0_4]

Thanks John. Much appreciated.

On another thread I found a link to http://masamiki.com/project and one of
the examples there caused me to recognise the subtle difference between
defining a variable as a 'Task' or as a 'Tasks'.
So I have found the answer to my basic question.
If you can tell me the syntax to round the number I have displaying in the
Text2 field to no decimal places that would be helpful!!

TESA0_4,
Try the Round Function. Its syntax is:
Round(expression[,number of decimal places])

You can read more about its syntax in the VBA help file.

By the way, "Tasks" is a collection of objects, and "Task" is an element
of that collection.
John
Project MVP

 

[John]

Thanks John. Much appreciated.

TESA0_4,
You're welcome.
John

On another thread I found a link to http://masamiki.com/project and one
of
the examples there caused me to recognise the subtle difference between
defining a variable as a 'Task' or as a 'Tasks'.
So I have found the answer to my basic question.
If you can tell me the syntax to round the number I have displaying in
the
Text2 field to no decimal places that would be helpful!!

:

I have some VBA knowledge but know zip about MS Project. I'm using
Project
to
display an aircraft servicing schedule prepared in Excel. The need is
to
display in a 'Text' or 'Number' column in Project the number of days
between
the planned start of a servicing and the planned finish date of its
(single)
predecessor. I can't figure out how to give a variable defined as a
task
the
value it needs to get the finish date of the predecessor task.
I'm sure this is a dead-simple question for even a Project novice so I
hope
someone can help.
Thanks for any help that you can offer.

TESA0_4,
Try the Round Function. Its syntax is:
Round(expression[,number of decimal places])

You can read more about its syntax in the VBA help file.

By the way, "Tasks" is a collection of objects, and "Task" is an element
of that collection.
John
Project MVP