All the information contained in MS Project can be exported to excel\word. Once the end template has been produced. The raw data can be used to Automate this proces, to produce EVM, WBS Forms, Estimate Request Forms etc..
Regards
Member for
19 years 5 months
Member for19 years5 months
Submitted by Svein Myklebust on Sun, 2006-05-28 04:06
Yes you can directly analyse time scale data into excel. Just activate the Analysis Toolbar and use the command "Analyze TimeScale Data in Excel" and follow the wizard
If the root problem is getting the charts and reports you need from Microsoft Project, I humbly suggest that you take a look at our software - DecisionCharts for Microsoft Project.
DecisionCharts now has over 90 bundled charts that provide managers with a live, interactive view into their projects (it even has multi-project capabilities). There’s no need to copy and paste into excel - If we don’t have the exact chart or report you need, we can create it. (We do this all the time for customers).
Please take a look at our website and contact me directly with any questions - Helping managers get the charts and reports they need from Microsoft Project is we do - I would be happy to help!
Exporting is neither the best nor the only way . Better use VBA to talk with both programms. Do you want an example ? May be I finaly can make somebody enthusiastic for this method. (also available in P3).
Hannes
Member for
22 years 9 months
Member for22 years9 months
Submitted by Alexandre Faul… on Thu, 2006-02-02 13:39
Member for
20 years 10 monthsRE: Linking MS Excel to Project
Hi All,
All the information contained in MS Project can be exported to excel\word. Once the end template has been produced. The raw data can be used to Automate this proces, to produce EVM, WBS Forms, Estimate Request Forms etc..
Regards
Member for
19 years 5 monthsRE: Linking MS Excel to Project
You might want to check out Safran for MSP.
I hav never used it myself, but are a happy user of Safran Procjet and Safran Planner.
http://www.safran.no/s4msp.htm
S
Member for
19 years 5 monthsRE: Linking MS Excel to Project
Yes you can directly analyse time scale data into excel. Just activate the Analysis Toolbar and use the command "Analyze TimeScale Data in Excel" and follow the wizard
Member for
20 years 1 monthRE: Linking MS Excel to Project
Hello Chris,
If the root problem is getting the charts and reports you need from Microsoft Project, I humbly suggest that you take a look at our software - DecisionCharts for Microsoft Project.
DecisionCharts now has over 90 bundled charts that provide managers with a live, interactive view into their projects (it even has multi-project capabilities). There’s no need to copy and paste into excel - If we don’t have the exact chart or report you need, we can create it. (We do this all the time for customers).
Please take a look at our website and contact me directly with any questions - Helping managers get the charts and reports they need from Microsoft Project is we do - I would be happy to help!
Regards,
John Garay
DecisionEdge, Inc.
jgaray@decisionedge.com
http://www.decisionedge.com
Member for
21 years 8 monthsRE: Linking MS Excel to Project
Hannes,
Yes any help would be good help. If you can send anykind of module / instructions to my work e-mail I would be happy, chris.murray@ctcmarine.com
Regards
Member for
20 years 3 monthsRE: Linking MS Excel to Project
Exporting is neither the best nor the only way . Better use VBA to talk with both programms. Do you want an example ? May be I finaly can make somebody enthusiastic for this method. (also available in P3).
Hannes
Member for
22 years 9 monthsRE: Linking MS Excel to Project
Hi there,
if your spreadsheet has a large nbr of rows, the best if not the only convenient way is to export to Excel.
Alexandre