XML Data query

Resolved · Medium Priority · Version 2007

Wed 18 May 2011, 15:45 Delegate Rohan said...

Rohan has attended:
Excel VBA Intro Intermediate course

XML Data query

A website I use has a XML data query tool. I have used macro's in teh past to capture this data. How can I do this in cleaner way?

http://www.bmreports.com/bsp/additional/soapserver.php

For example

SOSO Historic section can be enabled by date using vba

Mon 23 May 2011, 13:10 Trainer Anthony said...

RE: XML Data query

Hi Rohan. Your link is to a PHP page, which generates an XML output and it's not being manipulated by VBA on that page, those are PHP controls presumably querying a back-end database. You could code sending the variables to the php page, possibly using the Web Query tool in Excel, which is accesible via VBA. You could then capture and parse the XML output and manipulate the data in the way you need.

Anthony

Mon 30 May 2011: Automatically marked as resolved.

Training courses