Import Project File

[Jim Aksel]

I would like to import certain (flagged) tasks from an MS Project file (2003
or 2007) and display a timeline in Visio (2003 or 2007).

What I am seeking is the ability to have Visio update its timeline by
obtaining information about specific tasks from an mpp file. Somehow I need
to tag (configure) the Visio Milestones, Intervals and timelines with
infromation from the Proejct mpp file (for example the Project file Unique
ID).

For those who have seen the new Timeline in Project 2010, I want to be able
to do that in Visio (2003 or 2007) using Project 2003/7 data.

Any ideas?

 

[AlEdlund]

Since your searching for a certain amount of specificity (and didn't say
what you wanted to code in) I'd start the code over here

http://project.mvps.org/vbacode.htm

and the Visio stuff over here

http://visguy.com/vgforum/index.php?topic=1160.0

al

 

[Jim Aksel]

VBA will work fine, I can get it over to VB.NET later. I think my client can
live with this as a macro.

It looks like I need to go puzzle through your code and see how to get the
information from Project as opposed to the Excel file. Fortunately, the Task
table in Project lends itself to this quite well.

Jim

 

[AlEdlund]

Visio 2007 Pro has a lot of data connectivity in it, which gives it
phenomenal flexibility. Under the covers you can feed the datarecordsets
with xml and there are examples in the Visio SDK on how to move from
datasets to datarecordsets. Some of the other guys have been posting custom
timeline shapes on Chris Roth's site as well.
al

 

[Jim Aksel]

I'll check for things on Roth's site.
BTW - I was searching the mvp news groups and didn't seem to find Visio. It
tells me there are no posts to microsoft.private.mvp.visio. That is the
group, right?
--

 

[AlEdlund]

The group is small enough that most of our communications are via e-mail.
al