Reading excel sheet

Dear everybody,

I have a schedule in MS project including 10 activities and I also have an excel sheet having duration time of 10 acitivities. How to write a code in order to read these value and export total duration time when I am using MS project.

Thanks in advance!

Are you reading the spreadsheet to import the durations into Project or are you reading MS Project to export the durations into Excel? Did you identify the tasks in the spreadsheet by Task ID or by Task Name?