Macros in MS Project

Microsoft Project
H
Hannes de Bruyne 👤 Member for 20 years 11 months
· Permalink

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.

M
manulal inasu 👤 Member for 20 years 8 months
· Permalink

Hi Zhang,



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



Manu.

Z
Zhang Haixiang 👤 Member for 21 years 2 months
· Permalink

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.

M
manulal inasu 👤 Member for 20 years 8 months
· Permalink

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.

H
Hannes de Bruyne 👤 Member for 20 years 11 months
· Permalink

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

Z
Zhang Haixiang 👤 Member for 21 years 2 months
· Permalink

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.


H
Hannes de Bruyne 👤 Member for 20 years 11 months
· Permalink

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

Z
Zhang Haixiang 👤 Member for 21 years 2 months
· Permalink

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.

Forum Sponsor

Top Posters

Erkan Polater
9 posts
Soheil Barekat
4 posts
Luis Jr Ngade
6 posts
Ben Welsher
1 posts
Rohan Dashputre
0 posts
AMECHI ANAKWENZE
2 posts
Jayaprakash Sekar
1 posts
arash.karmand
0 posts
James Williams
74 posts
Vahidazimi01
0 posts