how to link excel data to ms project data

Dear experts,

Is there any way to link excel data that will automatically link and change data in ms project, i.e : if i change the date coloumn in excel the ms project data will change automatically

Thank you
budi salehProject SchedulerAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Dr. Thomas HenkelmannDirector Consulting ServicesCommented:
Hi,

in general there are two very different ways to achieve this.

1. Change data in Excel and update Project during opening of a project file or on demand by the user working in Project. This would require to setup a field mapping in Microsoft Project: save project as XLSX and then map fields from Project to Excel for export first. Then use this field mapping also to update the project schedule from the exported Excel file back to Project.

2. Create VBA code in Excel that uses Microsoft Project as remote object. Then you can open a Project file (MPP) and update individual fields in Project via the object model based on data in Excel

The first option might be the easier as a start, but the second is the more powerful as you have access to EVERY field in your project schedule, even resource assignments, constraints etc.

Hope this helps as a starter

Thomas
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Martin LissOlder than dirtCommented:
I've requested that this question be closed as follows:

Accepted answer: 500 points for thausla's comment #a40911251

for the following reason:

This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.