Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Solutions Through Learning

Excellent

Request Callback We will call you back

0207 987 3777 Call for assistance

Your Basket Basket is empty

Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Xml query

Xml query

ResolvedVersion 2007

Wed 18 May 2011, 15:56 Delegate 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")

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

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.

Excel tip:

Quickly create a list of numbers

The fill handle in Excel has many uses. If a number is typed into a cell and then the fill handle is used, the number will be copied from one cell to the next.

If you wish to create a list of numbers that increment by one at a time, hold down Ctrl in conjunction with using the fill handle - this should give you a series of numbers (e.g. 1, 2, 3 etc) rather than copying a single number.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Xml query

Xml query

RE: xml query

Excel articles

Excel tip:

Quickly create a list of numbers