XML Data

[SJW62]

I am a new user of VBS. I have a web site that when given the
(

http://10.1.1.50/CGI/webXML.exe?name=Steve)

URL, with arguments, returns, XML formatted data. I would like to pull that
data into some sort of record set that I can walk through. I need to do
this dynamically. What object should I use?


Thank you,



Steve

 

[BobRodes]

Like this, assuming that ADO works the same in VBA as it does in VB:

Dim rs As ADODB.Recordset
Set rs = New ADODB.Recordset
rs.Open "myxmlfile.xml", "Provider=MSPersist"

If it doesn't, perhaps someone else can show how to use ADO.

HTH

Bob

 

[SJW62]

Thanks for the help BUT "ADODB.Recordset" dose not appear to be valid for Excel’s VBA. The error I get is "User-defined type not defined”.

 

[PHV]

You have to reference the Microsoft ActiveX Data Objects 2.x Library.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[BobRodes]

Ok, so it does work the same. Thanks, PHV.

Bob