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

Please Login or Register  to view this content.

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!