I have got a querie about linking MS Project and MS Excel. I want to create a database query within excel so that I would be able to update the excel sheet directly from a source msp file. I have too many programm plan and I have got an excel sheet that contains an extract of all the milestones from the programm plan. The excel sheet is updated on a weekly basis and updates made on RAG status, milestone end date and % complete. I have been using a milestone code to refrence from excel to project. Its a manual process of checking each individual milestone in the programm plan, its a long process. I was wondering if we can automate this using an ODBC connection so it updates the data automatically and it will cut down an hours work to the click of a button. Can anyone suggest me how to do this? Thanks.
Bookmarks