Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Xml 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 query
Resolved · Medium Priority · Version 2007
Reply Wed 18 May 2011, 15:56Delegate Rohan said...
Rohan has attended:
Excel VBA Intro Intermediate course
Xml query
http://www.bmreports.com/bsp/additional/soapfunctions.php?output=XML&dT=2011-02-02&element=SYSPRICE&submit=Invoke
How can I change the date in the above xml query, by enter the wanted date in excel (For example Cell "A2")
For upcoming training course dates see: Pricing & availability
RE: xml query
Hi Rohan, thanks for your query. If you just want to alter the date in that url string simply use some concatenation:
In cell a1:
="http://www.bmreports.com/bsp/additional/soapfunctions.php?output=XML&dT=";
a2
<your date>
a3
= "&element=SYSPRICE&submit=Invoke"
Then in A4:
= A1 & A2 & A3
Hope this helps,
Anthony
Mon 30 May 2011: Automatically marked as resolved.
|