Link Excel to Microsoft Project

[fcohen]

Hi all,
I need to link an excel cell to the % of work complete in an Microsoft Project Plan.
Is there any way to do this?
Thanks,
FC

 

[Fazza]

hello

I'm unfamiliar with MS Project Plan. Is that different from MS Project?

MS Project connection string information is available such as at https://www.connectionstrings.com/ms-project/

Maybe via google you can find the connection string for MS Project Plan.

With ADO or similar, and using the appropriate connection string, one can have Excel query MS Project.

I'm guessing you're unfamiliar with this. But then I'm unfamiliar with MS Project Plan. Do you know what table or query in MS Project Plan has the information? Or do you know how to determine the required result from the tables/queries in MS Project Plan? If so, I can help with the specific SQL.

The basic idea, FYI, if using VBA would be a little like below. With the specific SQL and the connection string sorted out.

  Dim objRS As Object


  Set objRS = CreateObject("ADODB.Recordset")
  objRS.Open strSQL, strConnection

  range("A2").copyfromrecordset objRs

  Set objRS = Nothing

OK?