I think you can try saving you schedule using .mdb format instead of .mpp.
you can access this .mdb file using Excel (ODBC) or Open it directly in MS-Access, then you can creat report or whatever you want. make sure not change data in this mdb file.
Because you are using the same file both in MSP and Excel, so there s no problem of static or dynamic.
Member for
19 years 11 months
Member for20 years
Submitted by Andrew Owenson on Fri, 2005-11-11 07:19
The best idea in my opinion would be to export (Push) the data to Excel each time using a macro or VBA. Although the data would still be static, it would be a matter of running one macro from Project which shouldn’t take too long.
The other option is to pull the data into Excel from inside the Excel spreadsheet. Best place for Excel/Access help is www.utteraccess.com.
Have fun!
Member for
19 years 11 months
Member for20 years
Submitted by Andrew Owenson on Fri, 2005-11-11 06:01
That is what I have done. I copied the cell and did a paste link in excel. The problem being each package has about 15 activivities times 3 planned actual and forecast times that by about 70 standard packages makes that 3150 links. This really slows down the opening and saving of the excel file, also makes the file quite large.
Andrew
Member for
19 years 11 months
Member for20 years
Submitted by Andrew Owenson on Fri, 2005-11-11 05:56
I could export the whole thing and use excel as a spreadsheet. I use excel as the form now. The problem with that is the information would be static, whereas by linking the information, when I update the MSP programme, the excel spreadsheet is also updated automatically.
Member for
19 years 11 monthsRE: Package Procurement Schedule in Excel
Zhang
Sounds interesting! - I will give it a go
Cheers
Andrew
Member for
20 years 6 monthsRE: Package Procurement Schedule in Excel
Hi Andrew,
I think you can try saving you schedule using .mdb format instead of .mpp.
you can access this .mdb file using Excel (ODBC) or Open it directly in MS-Access, then you can creat report or whatever you want. make sure not change data in this mdb file.
Because you are using the same file both in MSP and Excel, so there s no problem of static or dynamic.
Member for
19 years 11 monthsRE: Package Procurement Schedule in Excel
Ian
I like the sound of that - will give it a go
Cheers
Andrew
Member for
22 years 3 monthsRE: Package Procurement Schedule in Excel
Andrew,
Have a look on the Microsoft Project Technet site - http://www.microsoft.com/technet/community/newsgroups/desktoppt/project.mspx and search for other answers or ask a specific question.
The best idea in my opinion would be to export (Push) the data to Excel each time using a macro or VBA. Although the data would still be static, it would be a matter of running one macro from Project which shouldn’t take too long.
The other option is to pull the data into Excel from inside the Excel spreadsheet. Best place for Excel/Access help is www.utteraccess.com.
Have fun!
Member for
19 years 11 monthsRE: Package Procurement Schedule in Excel
Sigfredo
That is what I have done. I copied the cell and did a paste link in excel. The problem being each package has about 15 activivities times 3 planned actual and forecast times that by about 70 standard packages makes that 3150 links. This really slows down the opening and saving of the excel file, also makes the file quite large.
Andrew
Member for
19 years 11 monthsRE: Package Procurement Schedule in Excel
Zhang
I could export the whole thing and use excel as a spreadsheet. I use excel as the form now. The problem with that is the information would be static, whereas by linking the information, when I update the MSP programme, the excel spreadsheet is also updated automatically.
Member for
24 years 5 monthsRE: Package Procurement Schedule in Excel
Hi Andrew,
How did you link the data of MSP to Excel?
Try this if you havent tried it yet. Copy the data cells you want to copy from MSP and paste it using paste special to excel.
Cheers,
Se
Member for
20 years 6 monthsRE: Package Procurement Schedule in Excel
why not export your programme to Excel, than do your Matrix in excel