Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

Macros in MS Project

10 replies [Last post]
Wed, 2005-11-02 12:07
manulal inasu
User offline. Last seen 18 years 14 weeks ago. Offline
Joined: 15 Oct 2005
Posts: 52
Groups: None
I know what macros are.

But could you please tell me some of the practical applications of macros in MS Project.

Are they really used by planners in MS project.

Where ever MS project is lagging behind Primavera, can we use macros programmed in VB to improve it?

Manu.
Top

Replies

Wed, 2005-12-21 04:24
#1
Hannes de Bruyne
User offline. Last seen 1 year 31 weeks ago. Offline
Joined: 25 Jul 2005
Posts: 154
Groups: None
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.
Top
Mon, 2005-12-19 14:52
#2
manulal inasu
User offline. Last seen 18 years 14 weeks ago. Offline
Joined: 15 Oct 2005
Posts: 52
Groups: None
Hi Zhang,

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

Manu.
Top
Mon, 2005-12-19 00:13
#3
Zhang Haixiang
User offline. Last seen 3 years 27 weeks ago. Offline
Joined: 14 Apr 2005
Posts: 250
Groups: None
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.
Top
Sat, 2005-12-17 12:36
#4
manulal inasu
User offline. Last seen 18 years 14 weeks ago. Offline
Joined: 15 Oct 2005
Posts: 52
Groups: None
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.
Top
Thu, 2005-11-24 04:23
#5
Hannes de Bruyne
User offline. Last seen 1 year 31 weeks ago. Offline
Joined: 25 Jul 2005
Posts: 154
Groups: None
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
Top
Tue, 2005-11-15 00:29
#6
Zhang Haixiang
User offline. Last seen 3 years 27 weeks ago. Offline
Joined: 14 Apr 2005
Posts: 250
Groups: None
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.

Top
Mon, 2005-11-14 04:18
#7
Hannes de Bruyne
User offline. Last seen 1 year 31 weeks ago. Offline
Joined: 25 Jul 2005
Posts: 154
Groups: None
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
Top
Wed, 2005-11-09 22:24
#8
Zhang Haixiang
User offline. Last seen 3 years 27 weeks ago. Offline
Joined: 14 Apr 2005
Posts: 250
Groups: None
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.
Top
Wed, 2005-11-09 05:22
#9
Christian Adrian ...
User offline. Last seen 4 years 38 weeks ago. Offline
Joined: 3 Jun 2003
Posts: 193
Groups: None
I believe it is best use in excel...
Top
Wed, 2005-11-02 12:13
#10
Vladimir Liberzon
User offline. Last seen 16 weeks 3 days ago. Offline
Joined: 5 Feb 2001
Posts: 2748
Groups: Accreditation Editors, Board of Advisors, Civil Engineering, GPCCAR Editors, Petro-Chem / Oil & Gas, Regional Representatives, Spider Project Team, TURNAROUND & SHUTDOWN (T/A & S/D)
Unfortunately you will not use macros for resource leveling.
Top