Package Procurement Schedule in Excel
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
Zhang
Sounds interesting! - I will give it a go
Cheers
Andrew
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.
Ian
I like the sound of that - will give it a go
Cheers
Andrew
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!
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
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.
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
why not export your programme to Excel, than do your Matrix in excel