Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » XML Data query
|
|
|
The UK's most regular Training information: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
XML Data query
Resolved · Medium Priority · Version 2007
Reply Wed 18 May 2011, 15:45Delegate 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
For upcoming training course dates see: Pricing & availability
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.
|