VBA macros are very powerful tools to overcome shortfalls in MSP. Most macros I have seen take info from MSP either to Excel or Access using DDE commands. (allows you to take info from one application whilst running another)
The main problem with the wizard function is that they commonly only allow for 1-step function which is fine but can just as easily be created using linked data between applications.
The beauty of VBA Macros is that data can be manipulated in various ways depending on the scenario you require.
I found the best way to learn is to create a single step macro using the wizard then you can edit this (tools Macro/Edit) and modify it accrodingly using the VBA tool help function which is quite explicit.
aslo there is a possibility in MSP and Excel while you do not know about VB, you can use from wizardof macro, it meanes you make a wizard then do something want to do macro and then stop wizard then you have a crated macro, you can use it in repated job again, it is very easy and use it very much.
Macros are written in VBA (Visual Basic for Applications). You may need to run your installation setup routine to ensure that you installed the VBA support for MS-Project.
The Help system explains how to use Macros, and the Visual Basic editor (Tools -> Macro -> Visual Basic Editor) also has a Help file. One good way to learn how to write Macros is to study ones that are already written.
Spider Project is most functional and powerful professional project management software.
The first SP version was launched in 1993 and since then it has been constantly improved. Today is used in 34 countries though most Spider Project customers are in Russia. Spider Project offers numerous unique functional features and is the only PM software that optimizes resource, cost, and material constrained schedules and budgets for projects and portfolios.
The unique features of Spider Project include Quantity Based Scheduling, Conditional Scheduling, Skill Scheduling, Optimal Resource, Cost and Material Leveling, Resource Critical Path Calculation, Cash and Material Flows Calculation and Management, Trend Analysis, Advanced Risk Simulation and Analysis, Calculation of Success Probability Trends, Calculation and Management of required Project Time and Cost Buffers, Application of Corporate Norms, Management of many Parallel Budgets, Multiple WBS and many others.
Spider Project was and is used for management of many large scale programs in Russia, including $51bln construction program for 2014 Winter Olympic Games preparation.
The application areas where Spider Project is successfully used include Aerospace, Banking, Construction, Defense, Energy, Engineering, Infrastructure, Manufacturing, Metallurgy, Mining, Oil & Gas, Railways, Retail, Shipbuilding, Software Development, Telecommunications, Utilities, etc.
P6-Auditor - Display information from Primavera P6 audit tables in a user-friendly format
Unifier-Archiver - Extract and archive important documents and attachments from Primavera Unifier
Unifier-Loader - Load data into and out of Unifier via Excel
PCM-Loader - Import data into Primavera Contract Management with flexible and secure, template-driven Excel spreadsheets
PCM-Archiver - Extract and archive important documents and attachments from Primavera Contract Management
PCM-Unifier Migrator - Automatically transfer live and historical data from Primavera Contract Management to Primavera Unifier with ease
Create Radically Better Construction Schedules with ALICE Technologies
Use the power of AI to create construction schedules that reduce risk while cutting costs and build time. With ALICE, develop the ideal schedule during preconstruction -- or recover projects that are off schedule and over budget.
but when I go in macro there is alot of text and I could not find fountion must to change it, there is a easily way.
VBA macros are very powerful tools to overcome shortfalls in MSP. Most macros I have seen take info from MSP either to Excel or Access using DDE commands. (allows you to take info from one application whilst running another)
The main problem with the wizard function is that they commonly only allow for 1-step function which is fine but can just as easily be created using linked data between applications.
The beauty of VBA Macros is that data can be manipulated in various ways depending on the scenario you require.
I found the best way to learn is to create a single step macro using the wizard then you can edit this (tools Macro/Edit) and modify it accrodingly using the VBA tool help function which is quite explicit.
Many tutorial books have been written.
yes I used this way but I could not understand how can I change my macro?
aslo there is a possibility in MSP and Excel while you do not know about VB, you can use from wizardof macro, it meanes you make a wizard then do something want to do macro and then stop wizard then you have a crated macro, you can use it in repated job again, it is very easy and use it very much.
Macros are written in VBA (Visual Basic for Applications). You may need to run your installation setup routine to ensure that you installed the VBA support for MS-Project.
The Help system explains how to use Macros, and the Visual Basic editor (Tools -> Macro -> Visual Basic Editor) also has a Help file. One good way to learn how to write Macros is to study ones that are already written.
Jack Dahlgren has posted a site with Microsoft Project Macros, Tools and Tips
HTH!
Bernard Ertl
InterPlan Systems Inc. - Project Management Software, Project Planning Software