Excel and MS project
Featured Partner
Top Posters
Zine Eddine
2 posts
Alex Lyaschenko
27 posts
mxsiegel
0 posts
Mattvtek
0 posts
Gareth Evans
3 posts
PP Admin
3, 129 posts
Rajkamal Tangirala
5 posts
Rahul Kumar
1 posts
blake333_
0 posts
Jeamiell Ostrovsky
2 posts
Our Partners
Another solution, is to use Visual Reports. They make Excel or Visio outputs, which are PivotTable/PivotChart or PivotDiagram (You can also make PivotTables with export feature). They all use a kind of map or template, which will be a handy tool, when youre going to repeat they same action.
Hi,
You have two way for this
1- create Dynamik link between Excle and MSP
2- Create Macro with VB or Internal Macro in excel
Yes and no.
Some Project data is available for easy display (Task Name, Task Start, Task Finish, Resource Name, Resource Group).
Some Project data is available only using VBA (Assignment Notes).
Some Project data is simply not available.
What data do you want to move from Project to Excel or from Excel to Project? Will you do this once? Or often?
If you want to view timephased information in MSP then you can use the Analyse Timephased data wizard. First you must select either Gantt Chart, resource usage or task usage view. Then either select a number of tasks or the whole schedule and open the view menu on the top toolbar. From the list select toolbars, analysis and then click analyse time phased data. This launches the wizard and from here you can make a number of selections.
Copy/Paste works quite well, as long as you make sure your columns align.
Another way is to open the Excel file from MS Project and use an import map. (if you open a file in MSP and choose XLS as file format, it will launch the import wizard automatically)
H.T.H.