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