Soap, VBA and Complex Types

L

Liz

I've used Microsoft Office 2003 Web Services toolkit to add a web
service to my Word 2003 VBA project. The function that is created in
the class is:

Public Function wsm_GetProfessional(ByVal str_employeeId As String) As
MSXML2.IXMLDOMNodeList
'*****************************************************************
'Proxy function created from
http://www.ropesgray.com/fcwsite/webservices/professionalservice.asmx?WSDL.
'
'"wsm_GetProfessional" is defined as XML. See Complex Types: XML
Variables in
'Microsoft Office 2003 Web Services Toolkit Help for details on
implementing XML variables.
'*****************************************************************

'Error Trap
On Error GoTo wsm_GetProfessionalTrap

Set wsm_GetProfessional =
sc_ProfessionalWebServic.GetProfessional(str_employeeId)

Exit Function
wsm_GetProfessionalTrap:
ProfessionalWebServicErrorHandler "wsm_GetProfessional"
End Function



So, I read the help and look up "Complex Types: XML Variables" and end
up writing the following sub:

Sub testweb()
Dim clsProf As clsws_ProfessionalWebServic
Dim msxRet As MSXML2.IXMLDOMNodeList

Set clsProf = New clsws_ProfessionalWebServic
Set msxRet = clsProf.wsm_GetProfessional("40170")
Debug.Print msxRet.Item(0).Text
End Sub


It returns:

(e-mail address removed)212-596-9090Stan
Jones has spent his career litigating intellectual property law
matters.  <font face=Verdana size=1><span
style="FONT-SIZE: 7.5pt; FONT-FAMILY: Verdana">He has
represented various clients in many well-known high profile
intellectual property disputes, including <?xml:namespace prefix =
st1 ns = "urn:schemas-microsoft-com:eek:ffice:smarttags"
/><st1:personname w:st="on"><?xml:namespace
prefix = st2 ns = "urn:schemas:contacts"
/><st2:givenname
w:st="on">Purdue</st2:givenname> <st2:sn
w:st="on">Pharma</st2:sn></st1:personname> in
<u>Purdue</u> v. <u>Endo</u>, Digital Equipment
in <u>Digital</u> v. <u>Intel</u>, Motorola in
<u>NBA</u> v. <u>Motorola</u> and Polaroid
Corporation in <u>Polaroid</u> v. <u>Kodak&lt
;/u>.</span></font><font face=Verdana
size=1><span style="FONT-SIZE: 8pt; FONT-FAMILY:
Verdana">  </span></font><font
face=Verdana size=1><span style="FONT-SIZE: 7.5pt; COLOR:
black; FONT-FAMILY: Verdana">He was a partner in Fish &
Neave from 1971 to 2004 and was Training Partner from 1985 to 1900.
Stan is a member of the Fish & Neave IP Group of Ropes
& Gray.</span></font><ul>
<li>American College of Trial Lawyers, Fellow
<li>American Bar Foundation, Fellow
<li>American Law Institute, Member
<li>Lawdragon 500: Leading Lawyers in America (2005, 2006)
<li>Lawdragon 3000: Leading Lawyers in America (2006)
<li><em>The National Law Journal's</em> 100 Most
Influential Lawyers in America <em>(</em>1997,
2000)
<li><em>The Best Lawyers in America</em> (since
inception)
<li><em>The World's Leading Lawyers for
Business</em>, "remains a true behemoth of the IP litigation
world"; "widely considered to 'belong at the top of the
tree'." (Chambers USA, 2006 and Chambers Global, 2005-06)
<li>Lifetime Achievement Award, Sedona Conference 2005
<li><em>Legal Times' Intellectual Property:</em>
<em>Who's Who in IP</em> (2001)
<li>Euromoney's <em>The Best of the Best</em>
(2000, 2004, 2006)
<li>Euromoney's <em>Guide to the World's Leading
Litigation Lawyers</em>
<li>Euromoney's <em>Guide to the World's Leading
Patent Law Experts</em> (2003, 2005)
<li>Euromoney's <em>Guide to the World's Leading
Trademark Law Practitioners</em> (2004)
<li>Euromoney's <em>Guide to the World's Leading
Technology, Media & Telecommunications Lawyers</em>
<li><em>New York Super Lawyers</em>
(2006)</li></ul><ul>
<li>Adjunct Professor of Law at the University of Pennsylvania
Law School since 1980, teaching courses in Patents, Trade Secrets,
Trademarks, Unfair Competition and Copyright Law
<li>Adjunct Professor of Law at New York University Law School
since 2003, teaching courses in Patents and Trademarks 
<li>Author, <em>Patent Law And Practice</em>, the
first edition of which as published in 1988 and the second edition in
1995 by the Federal Judicial Center, the third edition in 2001 and the
fourth edition in 2003 by BNA.  All editions have been made
available to all Federal Judges.
<li>Co-author of a 1998 patent law casebook entitled
<em>Principles of Patent Law</em>. The second edition was
published in 2001 and the third edition in 2004.
<li>Advisor, The American Law Institute Project -- Intellectual
Property: Principles Governing Jurisdiction, Choice of Law, and
Judgments in Transnational Disputes
<li>He has testified at different times before Congress at its
invitation on issues relating to innovation and patent law reform
<li>Served as a Special Master in patent litigation
<li>Trustee and Member, Corporation of the Woods Hole
Oceanographic Institution in Woods Hole, MA
<li>Director, International Intellectual Property Institute in
Washington, DC
<li>First Lieutenant, United States Army Signal Corps,
1957-59</li></ul>http://www.ropesgray.com/files/Professional/e5a27069-ef9f-4ae9-be48-60cf6fde7046/
<li>American Bar Association
<li>American Intellectual Property Law Association
<li>Association of the Bar of the City of New York
<li>International Trademark Association


My question is - how do I parse this?

Thanks,

Liz
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top