VBA for Project 2002

[Jack M.]

I am a beginner and need direction on training tools for automating MS Project 2002. Can someone recommend books...etc that would help me to learn VBA. I have some programming exp. but very limited. Any suggestions are appreciated.

 

[John]

Jack,
One good place to look is the MVP webpage at: http://www.mvps.org/project
Hit the "Links and Downloads" and look for "Project 98 Visual Basic
Training Environment Materials" at the bottom of the page. Even though
it says it is for Project 98, it is equally applicable to all later
versions of Project. The only real difference is that later versions add
more objects to the Project object library.

You can also find several nice examples of VBA code on Jack Dahlgrens
webpage at: http://masamiki.com/project/macros.htm

Enjoy VBA, I surely do.
John

 

[Mark Durrenberger]

Another handy way to get into VBA is to record macros then look at them.

Tools/Macro/Record
Do some stuff (like add a column to a table, enter data etc...)
Tools/Macro/Stop recorder

Tools/Macro/Visual Basic Editor (Alt-F11)
Expand the '+' in front of "ProjectGlobal" (left side of screen normally)
Expand the '+' in front of "Modules"
The macro you just recorded will show up as the highest numbered module
Double click on it to see your code. There should also be some MS provided
examples like Format_Duration and Rollup_formatting.

Have fun.
Mark

--
_________________________________________________________
Mark Durrenberger, PMP
Principal, Oak Associates, Inc, www.oakinc.com
"Advancing the Theory and Practice of Project Management"
________________________________________________________

The nicest thing about NOT planning is
that failure comes as a complete surprise and is not
preceded by a period of worry and depression.

- Sir John Harvey-Jones

I am a beginner and need direction on training tools for automating MS

Project 2002. Can someone recommend books...etc that would help me to learn
VBA. I have some programming exp. but very limited. Any suggestions are
appreciated.