Macros in MS Project
Featured Partner
Top Posters
Mattvtek
0 posts
Gareth Evans
3 posts
PP Admin
3, 129 posts
Rajkamal Tangirala
5 posts
Rahul Kumar
1 posts
blake333_
0 posts
Jeamiell Ostrovsky
2 posts
Hamzah Ahmed
0 posts
Quinton van Eeden
3 posts
Sunchana Johnston
12 posts
Our Partners
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.
Hi Zhang,
Thank you. I have already started learning more about macros 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.
Its better to go through all the objects in MSP.
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.
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.
Ive 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.