VBA macro in Excel to control Project
 

Hi,
I am trying to create a macro where at the click of a button, MS Excel
takes the data from cells containging a "Step Name" "Start date" "End Date"
and "List of Resources" and creates a MS Project document containing this
info.
Any suggestions on how to do this would be helpful, but the way I
currently have it going and NOT working is by using a already created linked
Project file that dynamically updates to reflect the datat in excel and
having the Macro open, update the linked info, save under a new name and
close. The problem is that the links remain after the save, and i want a
static file in the end. So perhaps someone could tell me how to use Excel
based VBA to programm Project to remove links from data.

Hopefully I get an answer.