Macros in MS Project

Unfortunately you will not use macros for resource leveling.

I believe it is best use in excel...

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.

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

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.

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

Hi,

Will the VB macros we use in excel work in MSP as well.
I learnt most of the macros coding in excel by recording a macro and then analysing the code. But this method does not seem to be easy in MSP.

Manu.

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.

Hi Zhang,

Thank you. I have already started learning more about macros in MSP.

Manu.

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.