Export task usage view to Excel

[Mark Stillman]

When I try to export (file - save as) the task usage view to excel, it only exports the "left side" columns (task name, duration, etc). How do you get the "right side" columns (work per month, cost per month) exported to excel as well?

 

[Rod Gill]

Hi,

Low tech: Copy Paste
Mid tech: use Visual Reports in Project 2007 or Analyze data in Excel
(Analysis toolbar) in Project 2003 or earlier
High tech: VBA macro. This is more complex but very flexible. See:
http://msdn.microsoft.com/en-us/library/ee355230(v=office.12).aspx

--

Rod Gill
Microsoft MVP for Project - http://www.project-systems.co.nz

Author of the only book on Project VBA, see: http://www.projectvbabook.com

When I try to export (file - save as) the task usage view to excel, it
only exports the "left side" columns (task name, duration, etc). How do
you get the "right side" columns (work per month, cost per month) exported
to excel as well?

---
frmsrcurl: http://msgroups.net/microsoft.public.project

__________ Information from ESET Smart Security, version of virus
signature database 5125 (20100518) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus signature database 5125 (20100518) __________

The message was checked by ESET Smart Security.

http://www.eset.com