Handle xml table as a recordset in excel vba

[somnath_it2006]

Hi All Experts..


I really want to complete this... If someone can Please help..

I have extracted xml table from sharepoint using below url (owssvr.dll):

http://ServerName/_vti_bin/owssvr.dll?Cmd=Display&XMLDATA=1&RowLimit=5&List={88479cb5%2D47b2%2D44fe%2D835c%2D0c4a335219e2}


Now I want to load this xml into some kind of recordset and extract require data from this table.
I want to work on this table as I work on access tables (Where I can execute the SQL queries.)

Please let me know if you have any ideas...

 

[somnath_it2006]

Some Excel MVP please look into this...