(Excel) Getting Started Spidering a Site

This is a very simple "getting started" example for spidering a web site. As you'll see in future examples, the Chilkat Spider library can be used to crawl the Web. For now, we'll concentrate on spidering a single site.

Download Excel Class Modules Chilkat Excel Class Modules

Dim spider As Chilkat.Spider
Set spider = Chilkat.NewSpider

' The spider object crawls a single web site at a time.  As you'll see
' in later examples, you can collect outbound links and use them to 
' crawl the web.  For now, we'll simply spider 10 pages of chilkatsoft.com
spider.Initialize "www.chilkatsoft.com"

' Add the 1st URL:
spider.AddUnspidered "http://www.chilkatsoft.com/"

' Begin crawling the site by calling CrawlNext repeatedly.

For i = 0 To 9

    success = spider.CrawlNext()
    If (success = True) Then
        ' Show the URL of the page just spidered.
        Debug.Print spider.LastUrl
        ' The HTML is available in the LastHtml property
    Else
        ' Did we get an error or are there no more URLs to crawl?
        If (spider.NumUnspidered = 0) Then
            Debug.Print "No more URLs to spider"
        Else
            Debug.Print spider.LastErrorText
        End If

    End If

    ' Sleep 1 second before spidering the next URL.
    spider.SleepMs 1000
Next