Archive for September, 2011

Found a good link covering options of converting different Office applications from trial to full. List of the application goes as :

  • Microsoft Access 2010
  • Microsoft Excel 2010
  • Microsoft InfoPath 2010
  • Microsoft OneNote 2010
  • Microsoft Outlook 2010
  • Microsoft PowerPoint 2010
  • Microsoft Publisher 2010
  • Microsoft Word 2010
  • Microsoft Project Professional 2010
  • Microsoft Project Standard 2010
  • Microsoft Visio Standard 2010

Refer here for the details : http://office.microsoft.com/en-us/project-help/convert-a-trial-version-of-an-office-2010-suite-or-program-to-a-full-retail-version-HA101886436.aspx

Read Full Post »

Thanks to a question asked by Ben, I thought of posting this write-up; MS Project 2010 has 32 bit color, so it has rich set of new and mesmerizing color set in its font color option which include Orange and variables shaded of blue and green. While MS Project 2007 has 16 bit color, so saving a 2010 font formatted file have impact when opened in 2007.

Here goes the list :

1. Orange could change to Red, lighter shades of Blue can turn to hyperlink blue etc. Implying that newer shaded of 2010 changes to some nearby shades in 2007.

2. Strike through tasks are not deleted in 2007, but strike through is removed.

3. Inactive tasks are deleted.

4. Manually scheduled tasks become Auto, as well constrains are set on them to trace their manual start or finish dates.

Other then that :

When you convert a Project 2007 file to a Project 2010 file, Project will operate in fully functional mode and not in compatibility mode. However, Project’s default behavior for new tasks will differ from new files that are created in Project 2010.

1. Existing Tasks of 2007 will remain to Auto mode in 2010.

2. New tasks created would be in Auto mode by defualt, unless changed to manual.

3. Task Mode column won’t be displayed by default and need to be inserted.

4. Master Project, displays with full functionality, but only those subprojects which are converted to 2010 would expand rest won’t.

5. Cross-project links from Project files that have not been converted to Project 2010 and that are contained within a file that has been converted to Project 2010 cannot be expanded. Cross-project links that are converted to Project 2010 can be expanded.

6. Resource Pool using projects when converted to 2010 would need Resource Pool also to be converted to 2010.

7. Fields used in Formula in 2007 would change to its equivalent fields in 2010.

Will list more points, as I come across, these are some very top level observations.

Read Full Post »

Please connect with us for free online over-view of MS Project 2010 /Project Server 2010. Based on the number of participants, The session’s dates will be announced soon, please leave us your contact and mail ID for further communication, in order for us to send you over the live meeting link.

Read Full Post »

Sub UpdateResourceCostRate()

Dim Res As Resource
For Each Res In ActiveProject.Resources
If Not Res Is Nothing Then

Res.CostRateTables(“A”).PayRates.Add “06/09/2011”, “$100/h”, “$200/h”, “0”
Res.CostRateTables(“B”).PayRates.Add “06/09/2011”, “$120/h”, “$240/h”, “0”
Res.CostRateTables(“C”).PayRates.Add “06/09/2011”, “$140/h”, “$280/h”, “0”
End If

Next Res

End Sub

Read Full Post »

Microsoft project Professional uses calendar extensively for scheduling tasks and leveling resources, but the API for calendars are not exposed in project server to list out all the non-working day, so here is a small piece of macro which uses calendar object loops through all the calendars and pushes the data to a custom table , and now you can report onto it as you wish,

Thanks to colleague Parth for sharing this code  🙂


Attribute VB_Name = “Module1”

‘Created By : Parth Rawal

‘Purpose : To Create the Exception data repository in the custom database for each project

Dim conDataAss As New ADODB.Connection

Dim cmd As New ADODB.Command

Sub calendar()

On Error GoTo Errorhandler


Dim cal As calendar

Dim i, j As Integer

Dim calName As String

j = 1

calName = ActiveProject.calendar.Name

i = ActiveProject.BaseCalendars(calName).Exceptions.Count


Dim rs As New ADODB.Recordset

With conDataAss

conDataAss.Open “Provider=sqloledb;” & _

“Server=ServerName;” & _

“Database=CustomDB;” & _

“User Id=userID;” & _


End With

cmd.ActiveConnection = conDataAss

cmd.CommandText = “CustomDB_PROJECT_CALENDAR” ‘SP Name

cmd.CommandType = adCmdStoredProc


For Each cal In ActiveProject.BaseCalendars

If cal.Name = calName Then

Do While j <= i

‘to insert the records for each project in the Custom database

If (conDataAss.State = ObjectStateEnum.adStateClosed) Then

conDataAss.Open ‘If connection is closed then open the connection

End If

cmd.Parameters(1).Value = CStr(ActiveProject.ProjectSummaryTask.Guid)

cmd.Parameters(2).Value = CStr(cal.Guid)

cmd.Parameters(3).Value = cal.Name

cmd.Parameters(4).Value = cal.Exceptions.Item(j).Name

cmd.Parameters(5).Value = cal.Exceptions.Item(j).Start

Set rs = cmd.Execute()

j = j + 1


End If

Next cal


Exit Sub


MsgBox Err.Description

End Sub


Read Full Post »

Older Posts »