Entries from Project tagged with 'vba'

Shutting down automatic site creation in Project Server 2007 and 2010

There are a couple of times you want to turn off the automatic site provisioning in Project Server and it is pretty easy to do by going to Server Settings / Project Site Provisioning and turning selecting the Allow users... read more.

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.

VBA returns in Excel 2011 for Mac

One of the things that I missed in the last version of Excel for the Apple Mac was that VBA was dropped. If you read this blog you will know how useful VBA can be for automating a bunch... 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.

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.

Microsoft Project VBA - the Instr function

The Instr function is used to find out if one set of characters (string) is contained in another. It can be used in VBA macros (in Word, Excel, Project etc.) and also in Microsoft Project and Microsoft Project Server Custom... 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.

Microsoft Project 2007 VBA Help now Available Online

Microsoft Project 2007 (and the rest of Office 2007) were released over the weekend (Nov. 12, 2006) and while it will take until early next year to make it through the retail channels you can at least get started with... read more.

Microsoft Project VBA the Rod Gill way

Rod Gill has put out a new book which covers most of what you need for Microsoft Project VBA programming. As far as I know it is the only book about VBA that I know of. The last edition of... 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 'vba'. [What is this?]

Subscribe to feed Subscribe to feed

Other Tags

Other tags used on this blog: