Export Resource exceptions details (non Working Time) to MS Excel

Recently created a macro to export resource non working time from MS Project to 2007/2010/2013 to MS Excel. It iterate through all work resources in current project plan and check for exceptions. It then exports resource name, Exception start and finish time to excel.

Use below steps to implement it.

1. Open the Project File
2. Press Alt + F 11
3. Right click on VBAProject(ProjectName) and select add Module
4. Copy the below code in the module

======================

Sub ResourceExceptions()

Dim MyXL As Object
Set MyXL = CreateObject("Excel.Application")
MyXL.Workbooks.Add
MyXL.Visible = True

MyXL.ActiveWorkbook.worksheets.Add.Name = "Exception Report"
MyXL.ActiveWorkbook.worksheets("Exception Report").Activate

Set xlRange = MyXL.activesheet.Range("A1")

xlRange.Range("A1") = "Resource Name"
xlRange.Range("B1") = "Start Time"
xlRange.Range("C1") = "Finish Time"
i = 2
    For Each R In ActiveProject.Resources
        If Not (R Is Nothing) Then
        ctr = 1
        If R.Type = pjResourceTypeWork Then
        If R.Calendar.Exceptions.Count > 0 Then
        For Each E In R.Calendar.Exceptions
        xlRange.Range("A" & i) = R.Name
        xlRange.Range("b" & i) = R.Calendar.Exceptions.Item(ctr).Start
        xlRange.Range("c" & i) = R.Calendar.Exceptions.Item(ctr).Finish
        ctr = ctr + 1
        i = i + 1
        Next
        End If
        End If
        End If
    Next R
End Sub

================

1. You can run this macro using view >> Macro >> view macro >> select ResourceExceptions and click run
2. To make this macro available for all project copy this macro in global.mpt. File >> Info >> Organizer >> Module >> Select "ResourceExceptions" from Project to global.mpt

Project 2010 webcasts

Please find the links for the few webcasts I delivered on Microsoft Project Server 2010

                                          i.    Project 2010: User Controlled scheduling

https://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032449811&culture=en-IN

                                         ii.    Project 2010: Team planner and SharePoint Task list sync

https://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032449814&culture=en-IN

                                        iii.    Project 2010: New Reporting functionality (Multiple OLAP Cubes, Excel Services and Visio Services integration for reporting)

https://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?EventID=1032449825&EventCategory=5&culture=en-IN&CountryCode=IN

                                        iv.    Project 2010: Demand Management

https://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032449927&culture=en-IN

                                         v.    Project 2010: Project Server 2010 new features

https://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032449829&culture=en-IN

Project publish button is disable

Welcome To My First Post!!!!!!!

Recently one of the users informed that he is not able to publish the project plan as the project publish button within Project Professional was disable. Below were the repro steps.

1. Close the project professional.
2. Open the project professional and connect to Project Server.
3. Open the plan from Project Server.
4. Make changes to the plan and save it.
5. Click on file menu
6. The Publish option is grayed out.

As a workaround we would requesting another project manager to open the plan and publish it.

Finally we tried below steps and it seems to resolve the issue.

1.       We closed the Project Professional.

2.       Launched the project professional and connected to server using problematic user account

3.       While launching the project professional we unchecked the “Load resource summary assignment” option.

4.       Opened the project plan and saved it.

5.       This time we found that the “Publish” button is not grayed out and was able to publish the plan

6.       We closed the project professional and launched the project professional with “Load resource summary assignment” selected.

7.       This time as well we were able to publish the plan.

8.       Not sure if uncheking the “Load resource summary assignment” option did the trick here.

Other suggestions:

1.       You may also try to delete the Project Professional profile for the user and create the new profile to check if that fix the issue.

2.       Check if user is working in offline mode.