Schedule Conversion

Jul 09 2010

Making Project look good in Excel

I often find it necessary to output sections of Project Schedules in a format that can be opened and edited by team members who are not comfortable with or do not have access to Microsoft Project. In most organizations, Microsoft Excel is a perfect solution, and Microsoft has conveniently included the ability to save as excel workbook from Project. However, the formatting of the export file is lost, with the most problematic aspect being the loss of indentation level of all tasks, masking the task groups and relationships. There is a simple solution. In about 5 minutes you can create a macro which will correct the indentation and greatly increase the legibility of the exported schedule. 

Read More

 

Disclaimer

The words and opinions expressed here are those of each article's respective author, and do not necessarily represent the views of CapTech Ventures.