Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Referencing .Net Remoting Services project in MS Excel Macro | Excel Discussion (Misc queries) | |||
Triggering Excel Macro from MS-Project | Excel Programming | |||
Excel macro to extract information from MS project files | Excel Programming | |||
Excel Macro exporting to MS-Project 2002 | Excel Programming | |||
Control Project From Excel | Excel Programming |