Anyone worked with writing a macro in excel where you can use the data in your excel file to copy data to microsoft project.

I have an excel file of task name, deadline, time remaining, and assigned to and I want to copy those 4 columns to a correlating column in project. So basically I would loop through these fields on each line til I reach a blank which could be entering a varied amount of tasks.

The full macro would change ms project start date to today's date then copy the 4 columns from excel to project to add a new task for each line in my file and then save the project file.

Anyone have any reference or knowledge on this or anywhere for me to start? I've seen some links on macro with project but most are more advanced then this or are exporting data from project to excel.

Thanks.