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.
© 2011 CapTech Ventures, Inc. All Rights Reserved. Legal Notices.