PPM Tricks

Powershell is becoming part of any IT-Administrator inventory. If you worked with Project Server 2013 or SharePoint 2013 you are properly avare of many of the many cmdlets available. Project Server - Powershell cmdlets For a list of the Project Server cmdlets see this Technet article:  http://technet.microsoft.com/en-us/library/ee890097(v=office.15).aspx MS Project - Powershell cmdlets Untill recently I was not aware you can access the MS Project client though Powershell. There is actally quite a big API available as you are simply attaching into the VBA/VSTO API. To connect to the MS Project client simply start up the Powershell ISE and use the following command. $Project = New-Object -ComObject msproject.application After you are connected the commands are very similar to the VBA counterpart, if you for example want to find the name of all the tasks. $Project.Visible = $True $tsks = $Project.ActiveProject.Tasks Foreach ($tsk in $tsks) { Writ...