13th February 2013, 10:03 AM
|
|
Member
|
|
Join Date: Mar 2006
Posts: 112
|
|
I'm Stumped with VBA & XML
Hi All,
I'm pulling the hair out and have googled myself silly, but I just can't work this out. I'm hoping Shaun or one of the other Excel experts can help me.
On Sheet2 Cells A3-A10 I have a list of URLs representing one meeting.
A3 =
h**p//tatts.com/pagedata/racing/2013/2/9/BR1.XML
etc
The macro I'm having hassles with -
Code:
Sub LoadRaceDetails()
Dim xmldoc As MSXML2.DOMDocument
Set xmldoc = New MSXML2.DOMDocument
xmldoc.async = False
xmldoc.Load ("h**p//tatts.com/pagedata/racing/2013/2/9/BR1.XML")
What I'm trying to achieve is to replace the URL (in blue) with code that will read Sheet2 Cell A3 and then loop to read Cell A4 etc - I'm pretty sure I can handle the looping.....
This XML stuff is doing my head in....
Thanks,
Den |