Exporting to Excel

[miltie]

Hello everyone,

This is my first post to this forum. I am exporting a MS Project file to Excel using the wizard. Is there a way to capture the formula's Project uses and have them export to Excel as well? Its a simple project plan, with task names, baseline start, baseline finish, actual start, actual finish and start and finish columns.

Not sure if this is possible, but appreciate the assistance in advance.

Paul

 

[PDQBach]

Using the export wizard, no.

Using VBA ... yes and no. It appears that the formulas are exposed but only for Enterprise fields and you won't see those unless you're using Project Pro and Project Server. We're not, so I can't explore this any further for you.

If you are using Project Pro and Server, then open the object browser and look for the CustomFieldGetFormula method and start your spelunking there.