Winproj 2007 VBA reading PSI ProjectDataSet

[Winnes]

Is this possible at all?

Wrote a .NET Class that has a public method returning ProjectDataSet

Would like to use this inside winproj VBA (RecordSet?)

 

[Kishore]

Winnes,
We have use the following Architecture

1) Wrote a Web Service in .Net for all PSI Calls
2) This Web Service returns required data as XML
3) VBA Macro calls this Web Service methods to call PSI calls and gets the
result in XML
4) In VBA, we had a generic method to convert XML to recordset...

Hope this helps.
Kishore

 

[www.projectserver.cz]

Winnes,
We have use the following Architecture

1) Wrote a Web Service in .Net for all PSI Calls
2) This Web Service returns required data as XML
3) VBA Macro calls this Web Service methods to call PSI calls and gets the
result in XML
4) In VBA, we had a generic method to convert XML to recordset...

Hope this helps.
Kishore







- Show quoted text -

Sample code which calling PSI from VBA is published on my blog.
http://projectserver.cz/cms/index.php?itemid=4