Quote Originally Posted by Norie
Stan
I've tried looking at it but it just doesn't seem to be working for me.
Norie;

It's just an ADO recordset, so it might look a little strange in Notepad due to the z:row configuration. Try placing the attached workbook in the same directory as the xml file, then run the show macro. My aim from the getgo was just to illustrate one methodology for web-scraping with a site such as Doug referenced. As you can see, I use a lot of late-binding and explicit constants... as normally I write my code outside the VBE, and run as separate compiled exes. Eventually Doug will need a relational structure of tables where

store
-----> subcategory
---->sub-subcategory
-----> Item

these will be a series of keys and urls, pointing to different sections, each sending different parameters to various code modules.

Stan