|Integrating MSProject w/ VB.Net [message #735]
||Sat, 29 July 2006 15:16
Registered: July 2006
I'm working on a small project that collects manufacturing lead time on a
number of components that are under development by our engineering
department. What usually happens is that the engineer will not have design
freeze until he / she is well inside the manufacturing lead time. That makes
it difficult (nearly impossible) for me to bring this component in on time
without huge expiditing fees.
What I have been able to do is build this manufacturing lead time into a
database that is used for tracking a number of items related to the project.
I would like to be able to export this information to MSProject. I currently
have an Access database saving all of the information. I managed to figure
out how to use VBA to open up MSProject, populate the fields, and publish
itself. The database is getting large, and the IS folks want to port it over
to SQLServer. So, I've been working w/ VB.Net on a new front end.
I'm to the point where I want to get the Gantt chart features up and
running. Can someone give me some step by step information as to how to go
about doing this. I don't necessarily expect code (although that would be
great!), I'm just looking to get pointed in the correct direction for my