Entries from Project tagged with 'programming'
Setting Microsoft Project Level Custom fields using VBA
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.
Iterating through Microsoft Project Subprojects
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.
Microsoft Project Undo Levels and Macros
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.
VBA and Visual Basic For ... to ... statements
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.
VBA to VSTO Tutorial Part Two - Adding a Command Bar and Buttons
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.
Making the move from VBA to VSTO in Microsoft Project
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.
Office VBA for Mac After 2008
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.
Analyze Microsoft Project Resource Usage Data In Excel
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.
VB / C# robotic car
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.
VBA Writing to a text file (MS Project, Excel)
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.
MS Project VBA - Trim Function
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.
Using a ComboBox in a Microsoft Project Userform
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.
Telling Time - ProjDateDiff, VB DateDiff and Application.DateDifference
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.
Working with the Project Object
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.
Working with the Tasks Collection
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.
Feed Subscription
If you use an RSS reader, you can subscribe to a feed of all future entries tagged 'programming'. [What is this?]
