I am a newbie to MS Project, but not necessarily VBA. I have built numerous scripts to do numerous tasks in Word, Excel, and Powerpoint. Acpi Cpl0002 Driver Windows 10 Dell.

However, I have been tasked to create a script in MS Project, an application that I have never used before. Normally, in Excel, I would simply obtain the column title by using the following: myvariable = ActiveSheet.Cells(1, x).Value However, I can see that MS Project has essentially 2 names for every field (column). They have the standard (Text1, Text 9, Number1, Number7, etc.) and they have the custom field name (My Data, Day of Week, EV, June, etc.) I would like to know how I would go about using VBA to see the custom name as well as the default name of each field (column). I prefer using MsgBox to see values that I need. I have figured out how to change the values within the table, but not the headers of the table. This seems to work for changing values within the table: Dim pj As Project Set pj = ActiveProject For Each t In pj.Tasks MsgBox t.GetField(FieldNameToFieldConstant('Number1')) '.

Hi, I'm afraid you want to do some Excel wthin Project, which will be troublesome. First, something you did not ask but still: instead of t.GetField(FieldNameToFieldConstant('Number1')) Use t.number1 The fieldnametofieldconstant is only useful for renamed fields. Countdown Vampires Psx Iso on this page. But then, why would you want to know the name of a column?

You practically never address a column in Project. Where the information stands or even whether or not it is visible in the active view is only rarely relevant. But if you want to play around, look up the help for TableFields and CurrentTable objects. Note that in Project, a Table is the collection of columns shown, not the sheet. And you may also be helped by the customfieldgetname method. ThKirkwoods, Yeah, Project VBA is an animal all to itself but once you get the hang of it, it works the same as any other application's VBA. Let's say I've renamed the Text1 field as 'customer' and that I've selected the column with that field.

Jan 07, 2017 Describes an issue that programmatic access to Office VBA project is. Microsoft Office Excel 2007 Microsoft Excel 2002 Standard Edition Microsoft. Project Explorer. The Microsoft Visual Basic window displays your VBA environment in Excel 2007: Next, let's take a few moments to analyze the various sections in the. More Vba For Microsoft Project 2007 videos. Book Landing Page: VBA Programming for Microsoft Office Project Versions 98 Through 2007 Module 19: Working with Timephased Data (VBA Programming for Microsoft Office.

The column can either be selected manually or by using the SelectColumn Method. The following statements will get, the field name, and the field custom name print FieldConstantToFieldName(ActiveSelection.FieldIDList(1)) Text1 print fieldnametofieldconstant('text1') 188743731 print customfieldgetname(188743731) customer Hope this helps. Well, I like your input, you seem to have answered exactly what I was asking. However, please excuse my ignorance (as I am only on my second day of learning MS Project).

I should have asked you how to set the Title. So, I guess it turns out that there are 3 possible headers to a 'column'. In my example, when I see the table that is in view, I have a particular column that says 'Apr 13'. The goal is to read that exact text for processing (I intend to cycle through the columns to perform this action on each column, searching for specific text). When I used your examples, I get the associated Results: Sub Test() DefaultName = FieldConstantToFieldName(ActiveSelection.FieldIDList(1)) MsgBox DefaultName ' Result>Number7 FieldConstant = FieldNameToFieldConstant(DefaultName) MsgBox FieldConstant ' Result>188743983 CustomName = CustomFieldGetName(FieldConstant) MsgBox CustomName ' Result>End Sub So now I ask, why can't I see 'Apr 13'?? Well, when I double click the header, I get a dialog that has 5 fields.

• Field name ->'Number7' • Title ->'Apr 13' • Align title ->Center • Align data ->Right • Width ->8 Something tells me that I need to obtain the 'Title' of the column, not necessarily the field name. Some columns have no Title at all, however. The columns that I am interested in, have text in the 'Title' field. To step back, here is a more general idea of what I need to do.

• Loop through each column to find which months are in the current view • Loop through each Task and review the number of days from Start to Finish for each Task (2 different columns - I'm thinking, get the date of start and finsih, and calculate behind the scenes based on the accounting calendar) • Take a certain calculation, based on those dates, and paste the result into another column (say, 'Split'). • Look in a 4th column, read the number of hours set aside for a given Task, and based on the split, spread those hours over the necessary months. Quite simple.basically, loop through tasks (solved), loop through columns, read data from various 'cells' (I think solved), and write new computed data to target 'cells'.