Macro time - Excel form into Project

[a-ron]

Hi Folks,

I'm not an advanced Project or Excel user by any means, so I wa
wondering if anyone had given thought to the following:

Could a simple macro be developed whereby certain information could b
input into a straight forward Excel form and then an .MPP create
automatically based on that info?

For example: I have an MS Project template with 3 tasks (engineering
procurement, assembly)... I setup an Excel form that looks somethin
like this:

PROJECT NAME:
ENGINEERING HOURS:
ENGINEERING RESOURCE (pick from list):
PROCUREMENT HOURS:
PROCUREMENT RESOURCE (pick from list):
ASSEMBLY HOURS:
ASSEMBLY RESOURCE (pick from list):
DESIRED START DATE:
and/or
DESIRED END DATE:

Could I create a macro to take the information filled out that nicel
formatted Excel form and automatically generate an .MPP?

Let me know if anyone has tried or thought about this

Thanks,
Aaro

 

[Mike Glen]

Hi Aaron,

Try posting on the microsoft.public.project.developer newsgroup. Please see
FAQ Item: 24. Project Newsgroups. FAQs, companion products and other
useful Project information can be seen at this web address:
http://project.mvps.org/faqs.htm

Mike Glen
Project MVP

 

[Rod Gill]

Hi Aaron,

This is easily done with VBA or you can import an Excel Template:
Open any project
File, Save As
Enter a name and select Excel Workbook as the file format
In the Export wizard that now starts, select Project template

The template stores Tasks in one sheet, Resources in another and Assignments
in a third.

You can also open any spreadsheet in this same format and have Project
import the data.

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com