Marco for multiple web quiries

I successfully made my own macro which scraped infomation from

URLs http://www.sda.gov.cn/WS01/CL0027/index_1.html...index_2.html...index_3.html etc.

using these code

Sub Macro1()
Dim i As Integer
For i = 1 To 83
'
' Macro1 Macro
'

'
    With ActiveSheet.QueryTables.Add(Connection:= _
        "URL;http://www.sda.gov.cn/WS01/CL0027/index_" & i & ".html", Destination:=Range("$A$1" _
        ))
        .Name = "index"
        .FieldNames = True
        .RowNumbers = False
        .FillAdjacentFormulas = False
        .PreserveFormatting = False
        .RefreshOnFileOpen = False
        .BackgroundQuery = True
        .RefreshStyle = xlInsertDeleteCells
        .SavePassword = False
        .SaveData = True
        .AdjustColumnWidth = True
        .RefreshPeriod = 0
        .WebSelectionType = xlSpecifiedTables
        .WebFormatting = xlWebFormattingAll
        .WebTables = "22"
        .WebPreFormattedTextToColumns = True
        .WebConsecutiveDelimitersAsOne = True
        .WebSingleBlockTextImport = False
        .WebDisableDateRecognition = False
        .WebDisableRedirections = False
        .Refresh BackgroundQuery:=False
    End With
Next i
End Sub

but I'm facing a little problem, actually the items in these URLs are added in a daily basis and the most recent info will be stored in
http://www.sda.gov.cn/WS01/CL0027/index.html while the outdated one will be moved to the subsequent pages i.e. index_1, index_2....

Thus, my questions are

1. How can i included the first page http://www.sda.gov.cn/WS01/CL0027/index.html in my macro loop?
2. Is it able to add a checking against the total number of pages so that the macro wont miss any newly added page?

I m just new to the macro stuff, any help would be appreciated!
Thanks in advance!

Sam.

wow~ it works like a charm! Thanks J!

but then is it out of the power of excel macro to deal with the second question?

Originally Posted by JBeaucaire

I didn't understand the second question. Perhaps someone else will.

Sorry for the confusing question:P

let me make it clear

Since the total NO. of URLs that this macro concerns would keep increasing in the future from 83...84....85...86...87......
It there any way to automatically get the NO. of pages? i.e. the i value isnt pre-defined but input only after checking the NO. of pages.

Thanks again!