How does the sample work? First update the server name to reflect your server. Then run the GetProjectList macro. It will populate the current sheet with Project names and Guids. Select the cell of the Guid for the Project you want to see details on, run the DisplayProjectDetails macro. A new sheet will appear with all the Project detail information.