Excel and MS project
Forum Sponsor
Top Posters
Julian Pegg
1 posts
Peter Nagy
2 posts
Raymund de Laza
17 posts
Syed_Asad
0 posts
Tony Greyvenstein
0 posts
Ahmed Al-Jubouri
13 posts
Umar Alvi
3 posts
Sibusiso Mahlalela
0 posts
Michael Samanyayi
3 posts
Simon Gumede
0 posts
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.