How to integrate web application to MS Project

[Paul Piper]

Hi,

I've been asked to allow a user of MS Project to click on a cell (which
would be perhaps be a hyperlink) to connect to the corresponding page of our
website (prefer the user not to have to sign in to
the website however it looks like they would have to).

The user would then add, edit or delete a form which would update the
corresponding cell in MS Project.

Can someone give me an idea how to do this please? Thanks?

 

[Jim Corbin [MSFT]]

You can easily add a hyperlink to a task, which shows in the Indicators
column (click a task, then click Hyperlink on the Insert menu).

It's a little harder to update the Project from the linked Web application.
Your best bet would probably be to wait a few weeks for the Visual Studio
codename Orcas Beta-2 release with Visual Studio Tools for Office (VSTO) --
now officially known as Visual Studio 2008. It will contain templates for
developing Project 2003 and Project 2007 add-ins (the Beta-1 release doesn't
have the Project templates).

I haven't tried this, but here's an idea. There is no Cell_Click event, but
for example, your add-in might try finding the ActiveCell.Task when you try
to change a task (maybe trap the ProjectBeforeTaskChange2 event). See, for
example,
http://projectserverexperts.com/Sha...eTaskChange and ProjectBeforeSaveBaseline.htm
or search for ProjectBeforeTaskChange event.

The Web application could expose a Web service that consumes the data you
send (ActiveProject, ActiveWindow, Task), and then returns the information
for the VSTO add-in to proceed to update or delete the task. It might make
sense to have the VSTO add-in do most of the work, including starting the
Web app, and maybe you don't need a hyperlink in the Indicators column.

If you develop a solution, I'd be interested in seeing it.
Thanks,
--Jim

 

[Dave]

Hi,

I've been asked to allow a user of MS Project to click on a cell (which
would be perhaps be a hyperlink) to connect to the corresponding page of our
website (prefer the user not to have to sign in to
the website however it looks like they would have to).

The user would then add, edit or delete a form which would update the
corresponding cell in MS Project.

Can someone give me an idea how to do this please? Thanks?

We publish our Project files to our intranet by creating gif images of
the Gantts and link to other pages by imagemapping the Gantts. This
way, users do not have to have Project installed on their computers -
all they need is a web browser.

Dave

 

[Dave]

Hi,

I've been asked to allow a user of MS Project to click on a cell (which
would be perhaps be a hyperlink) to connect to the corresponding page of our
website (prefer the user not to have to sign in to
the website however it looks like they would have to).

The user would then add, edit or delete a form which would update the
corresponding cell in MS Project.

Can someone give me an idea how to do this please? Thanks?

However, this solution doesn't allow you to update the Project file
from the web...