Welcome To Masamiki.com
October 5, 2016
This site is here to provide information about how to get the most out of Microsoft Project. You will find sections on writing macros to automate Microsoft Project, a brief discussion on calculated fields and a section which documents the new features available in Project 2002.
Project comes in many different versions. The information here is rather brief. To be honest, the difference between Project 2002 and 2003 (at least in the standard version) is so small that I hardly bother to upgrade.
If you are using Project Server, the differences are more meaningful. I would even classify Project Server 2003 as a just a big service pack for 2002 which fixes many of the problems and bugs which were in 2002. That and an upgrade to WSS.
VBA and Macros:
There are many things that people would like project to do which are not built in to the standard tool. Fortunately, there is a way to get project to do almost anything that you want. This is through the use of VBA (Visual Basic for Applications) which is Project’s built-in programming language. It is common with the other Microsoft Office Tools such as Excel and Word so that you can interoperate with those tools to extend the capabilities of Project. I have a number of examples of this available to get you started with it.
Other Macro Information:
Example with Excel – A free Monte Carlo Simulation macro which illustrates how Project and Excel can work together.
Macros or Calculated Fields – Project 2000 introduced calculated fields. What they allow you to do is use any of the custom fields (Text, Number, Date, Cost, Flag …) and use a formula to calculate what is displayed in that field. They are often a good replacement for a macro. This page describes when you would prefer one over the other.
Calculated Field FAQ – There are some common problems people have with Calculated fields. T his FAQ answers some of the Frequently Asked Questions.
Scheduling with Excel:
This part of the site is mostly concerned with Microsoft Project, but that doesn’t mean you have to use it. Often I find that other tools such as Powerpoint or even Excel are more suited to a particular situation. If you fall in this category I’ve put together a sample file which shows how you can use things like conditional formatting and formulas to use Excel as a scheduling tool.