I have a situation where I need a VBA function to find some information from children tasks. The function works well when I call it from Immediate window in MS Project VBA in Global.MPT. The function is a public function and so i would expect to have access to it from the Formula in the custom field. However, I cannot see it in the lists of possible functions and I get a syntax error when I key it in manually. This is what I key in the formula: SummarryStatus([Unique ID]). I have other functions and subs in Global.mpt which execute when I open the project and when I press the Macro shortcut.

I am quite new to VBA, but thanks to you and google I managed to put a task I created in MS Project as a meeting in the Outlook calendar of the assigned resource.

I have an add-in that works in Microsoft Project Professional 2019. Will this same add-in work in Microsoft Project Online Desktop Client?

I want to set up a rolling 2 week look ahead filter in MS Project. I know how to add 14 days to today using now() + 14 however it would be better if it use the date of the Friday in 2 weeks time. Hence if I was to run it today (10th June) it would show tasks which started before Friday 28th June. I would also show the same tasks if I was to run it on the 11th, 12th … 14th. This has two advantages – 1) it fits with how the business people think and 2) it allows me to run the report at any time.

I’d like to be able to set the remaining cost of a Cost (pjResourceTypeCost) type resource assignment, but the RemainingCost property of the assignment is read-only, so something like this doesn’t work:

I would like to create a task in my project which spans the duration of a summary task. I have a summary task which encompasses several tasks, with their own respective dependencies. I would like to create an actual task (not summary) that spans the same duration as this summary task. I can somewhat accomplish this by scheduling a standard task with “Start-To-Start” using the first task under the summary, and “Finish-To-Finish” of the last task in the summary. However, if I reorder the tasks under the summary, the new task, which I want to be the same duration as the summary, won’t update according to the beginning and end of the summary task, but rather the beginning and end of the previously first and last tasks of the summary. The attached image should help clarify what I mean.