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.
Member for
22 years 4 months
Member for22 years4 months
Submitted by Mehdi Rashidi … on Tue, 2007-10-30 05:59
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.
Member for
20 years 7 months
Member for20 years8 months
Submitted by Niek Zonneveld on Mon, 2007-09-10 07:32
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)
Member for
18 years 10 monthsRE: Excel and MS project
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.
Member for
22 years 4 monthsRE: Excel and MS project
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
Member for
18 years 3 monthsRE: Excel and MS project
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?
Member for
18 years 8 monthsRE: Excel and MS project
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.
Member for
20 years 7 monthsRE: Excel and MS project
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.