I am attempting to write a VB macro for MS Project and I'd like it to basically find the task with the latest start date in a project. It sounds simple, but I haven't been able to do it yet. Any help would be greatly appreciated.
I don't use MS Project VBA. However, there are similarities in the MS Object models and thre are things that apply across the board on VBA.
We really need a starting point. You have been doing stuff in MS Project VBA. You ought to know something about the Object Model, collections and Object Properties.
Brute force, at least you could loop thru the Task Collection and look at the Start Date property and find the largest value. Code it as a function that you could use on other properties to return a MAX value.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.