Macros in MS Project

hello Manulal



of course you can also use these MSP-macros from an Excel-Task. I.e. that you can transfer data very easily and use the graphical possibilities of excel to show the information of MSP. Or even better - you can connect to AutoCAD or P3 using these macros.

They are almost the same. The difference is the objects(events,method...). You can learn these from the HELP file,also recording & studying.



It’s better to go through all the objects in MSP.

Hello Zhang



thanks for the answer, it is realy a nice idea. I would even be more happy if you could copy some of the macro-text in your answer. As I said I work a lot with macros too and I noticed in the past, that people work in very diffent ways with macros. Those different approaches are the things that interrest me, because from that I can learn a lot more than from the examples of Microsoft



Regards Hannes

just use taskdependency object to check each pred of current selected task, and use the link type & lag to calculate the start date of the current selected task, if the date equals to the start date of the current selected task, then consider it as driving pred.

Hi Zhang,



this sounds very interesting. Is it possible to put this macro in this forum (just as text). I like writing makros as well and its always good to learn from ideas of other persons.



Thanks

Hannes

Yes, you can use macro to imporve MSP.

I’ve write a macro to make a predecessor form the same as P3, using * to indicate driving preds.

I believe it is best use in excel...

Unfortunately you will not use macros for resource leveling.