Exporting MS Project Values into Excel

[Paul Peterson - Velox Consulting, LLC]

Two quick questions. 1 - Is there anyway to eliminate the "h" on duration,
actual work, etc., when saving a project plan to excel? 2 - Is there a way
to save to a worksheet within an excel file when saving to excel?

Paul C. Peterson
Velox Consulting, LLC

 

[Rod Gill]

Hi,

1) In Excel, select all cells with work values then do an Edit, Replace and
replace "h" with ""

2) I don't think so.

--

Rod Gill
Microsoft MVP for Project

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



"Paul Peterson - Velox Consulting, LLC"

 

[Paul Peterson - Velox Consulting, LLC]

Thanks Rod. I've actually built a macro do make the changes but I have some
challenges to execute it automatically.