Can I call a web service from VBA code?

[angus404]

I am migrating from Project Server 2003 to Project Server 2007. I have a lot
of VBA code that I do not want to have to rewrite. The project 2007 server is
going to sit in the DMZ and will have to access a SQL server (different from
the Project SQL server) through a firewall.

In 2003 I am using ODBC calls, but they won't go through the firewall, so I
was going to write a web service that would return the data I needed. Is
there any way to call a web service from VBA code in Project 2007?

 

[Stephen Sanderlin]

Yes, you can, but it's extremely painful because you have to handle the
XML directly as opposed to using the proxy classes that Visual Studio
will generate from the WSDL.

Take a look at http://projectserver.cz/cms/index.php?itemid=4 for an
example.

You're going to have to write a lot of additional code to convert your
ODBC calls to PSI operations from VBA... you should seriously consider
changing to VSTO and using .NET... it will make your interactions with
the PSI significantly easier.

--
Stephen Sanderlin
Principal Consultant
MSProjectExperts

For Project Server Consulting: http://www.msprojectexperts.com
For Project Server Training: http://www.projectservertraining.com

Read my blog at: http://www.projectserverhelp.com
Join the community at: http://forums.epmfaq.com