Basically I need a sitemap. But I do not need the 4 or 5 different pieces of info that a sitemap puts with each webpage, like how often the webpage is likely to change, and then submits to a search site like google. I need a list of every webpage on the site and that is all.

I do not want to automate ie to go to a site that creates a sitemap for you. I tried that and then their site went down soon after. I would prefer to figure it out and do it myself from a macro.

I want it to work for different websites written and hosted differently from each other. How can I do this in Excel VBA? I have googled and found SiteMapPath. I can only find examples of it used with asp.net I think. I am having a hard time getting started with this at all in VBA. Thanks!