<div>
thanks! i'll prob ask a follow up question on this in how to map the xml to columns (next step)
</div>


thanks! i'll prob ask a follow up question on this in how to map the xml to columns (next step)

<div>
<div class="content wysiwyg-content">
Folks<br />
<br />
How can I build an http call in a vb macro and parse the results into excel, the code works<br />
<br />
POST <a href="http://testproject:80/integration/os/resources" rel="ugc">http://testproject:80/integration/os/resources</a><br />
Content-Type: text/xml<br />
&lt;max:QueryRESOURCES xmlns:max=&quot;<a href="http://www.vendor.com/projects" rel="ugc">http://www.vendor.com/projects</a>&quot;&gt;<br />
&nbsp;&lt;max:RESOURCES Query&gt;<br />
&nbsp; &lt;max:WHERE&gt;upper(FIRSTNAME<wbr />) like 'A%'&lt;/max:WHERE&gt;<br />
&nbsp;&lt;/max:RESOURCES Query&gt;<br />
&lt;/max:QueryRESOURCES
</div>
</div>


Folks

How can I build an http call in a vb macro and parse the results into excel, the code works

POST http://testproject:80/integration/os/resources
Content-Type: text/xml
<max:QueryRESOURCES xmlns:max="http://www.vendor.com/projects">
 <max:RESOURCES Query>
  <max:WHERE>upper(FIRSTNAME) like 'A%'</max:WHERE>
 </max:RESOURCES Query>
</max:QueryRESOURCES

http post from excel using macro

VBScript (Visual Basic Scripting Edition) is an interpreted scripting language developed by Microsoft that is modeled on Visual Basic, but with some important differences. VBScript is commonly used for automating administrative and other tasks in Windows operating systems (by means of the Windows Script Host) and for server-side scripting in ASP web applications. It is also used for client-side scripting in Internet Explorer, specifically in intranet web applications.

VB Script

The Hypertext Transfer Protocol (HTTP) is an application protocol for distributed, collaborative, hypermedia information systems. Hypertext is structured text that uses logical links (hyperlinks) between nodes containing text. HTTP is the protocol to exchange or transfer hypertext. HTTP functions as a request-response protocol in the client-server computing model. HTTP is designed to permit intermediate network elements to improve or enable communications between clients and servers. HTTP is an application layer protocol designed within the framework of the Internet Protocol Suite; it presumes an underlying and reliable transport layer protocol.

HTTP Protocol

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.