I was recently trying to set a number of different project level custom fields using VBA and got tired of finding and editing all the parameters so I wrote a small wrapper function that you may find useful: Private Function... read more.>
Master Projects in Microsoft Project don't always behave the way you expect, especially if you are trying to iterate through all the tasks in them. The reason is that the file doesn't really contain the subprojects, it merely acts as... read more.>
One of the new features of Project 2007 is that it allows more than one level of Undo. This is of great comfort to those of us who have made more than one error while working on a file.... read more.>
Most of the Microsoft Project or Excel macros I write include looping through a collection of tasks or resources or assignments and use the a For Each ... Next loop, but that doesn't mean we should neglect the For ...... read more.>
In my previous tutorial on using VSTO to create a Microsoft Project Add-in, I covered what is necessary to create an Add-in which displays a simple form but most of the time we don't want the form to show up... read more.>
One of the most useful features of Microsoft Project is the ability to automate actions with it. Primarily this is done by writing VBA (Visual Basic for Applications) code, or by just recording a macro and then editing the VBA... read more.>
For those who work on Apple Macs there was some good news today. Microsoft announced that it is bringing back VBA support for the Macintosh version of Office. Support will be coming in the versions after 2008. Here is the... read more.>
The "Analyze Timescaled Data In Excel" add-in which ships with Microsoft Project has a couple of limitations, the first is that it is not easy to find, and the second is that it is task-based only, so if you want... read more.>
A new article on making your own robotic car using Microsoft Robitics Studio was posted here Bill Gates has been quoted as saying robots are the next frontier (or something like that).... read more.>
One common question is how do I write from an office app like Excel or Project to a text file. I have the code embedded in a few samples here, but this short sample shows it most clearly. There are... read more.>
Solving a recent custom field formula problem required reaching into the toolbox and pulling out the trim() string function. Trim is one of the simplest string functions. It does one thing and does it well. It just strips any leading... read more.>
I got a question from someone who wanted to create a userform which would set some values in project. It was to be populated by some preset values. So here are the basics: The first thing to do is to... read more.>
Date subtraction in VB, Project VBA and Project custom field formulas is one of the more common activities. Unfortunately there are a number of slightly different functions available. This article briefly describes the main three. It all starts with the... read more.>
The Second in a Series of Short Notes About Using Project VBA Using a Project object of some kind is essential to programming Project. Like the Task object, it is also a member of a collection, in this case it... read more.>
The First in a Series of Short Notes About Using Project VBA The tasks collection is simply a collection of all the tasks in a project. It is the starting point for most Visual Basic programming exercises so it is... read more.>
If you use an RSS reader, you can subscribe to a feed of all future entries tagged 'programming'. [What is this?]