How to download multi pages of table from the web

[lubbamkt]

hi, I would like to download tables from this web site (http://sdinotice.hkex.com.hk/di/NSAl...=MAIN&lang=EN&)

My question is sometimes there are 2 pages of the table while sometimes there is only 1 page. How could I download the entire table if there are more than 1 page of the table? Thanks

Here the HTML code for the number of pages of the table
(<TD align="left" bgcolor="#cccccc" class="boldtxt">
<span id="lblPageIndex">Page <a style="font-size:15px;font-weight:bold" href="/di/NSAllFormList.aspx?sa2=an&sid=25860104&corpn=GOME+Electrical+Appliances+Holding+Ltd.&sd=14%2f10%2f2013&ed=26%2f09%2f2014&sa1=cl&scsd=13%2f10%2f2013&sced=13%2f10%2f2014&sc=493&src=MAIN&lang=EN&&pg=1"><1></a> <a style="font-size:14px;font-weight:bold" href="/di/NSAllFormList.aspx?sa2=an&sid=25860104&corpn=GOME+Electrical+Appliances+Holding+Ltd.&sd=14%2f10%2f2013&ed=26%2f09%2f2014&sa1=cl&scsd=13%2f10%2f2013&sced=13%2f10%2f2014&sc=493&src=MAIN&lang=EN&&pg=2">2</a> <a style="font-size:14px;font-weight:bold" href="/di/NSAllFormList.aspx?sa2=an&sid=25860104&corpn=GOME+Electrical+Appliances+Holding+Ltd.&sd=14%2f10%2f2013&ed=26%2f09%2f2014&sa1=cl&scsd=13%2f10%2f2013&sced=13%2f10%2f2014&sc=493&src=MAIN&lang=EN&&pg=3">3</a> </span>&nbsp;</TD>)

[Naveed Raza]

Try this below code and have test on 2 Pages as well

Please Login or Register  to view this content.

[lubbamkt]

Thanks Naveed Raza, I got 2 questions
1.) the procedure only returns the data from page 1 only no matter I changed the figure to sWebTable
2.) how should I set the variable to sWebTable in case I want vba to determine how many pages the table contained instead of I hard-code a figure?

Try this below code and have test on 2 Pages as well

Please Login or Register  to view this content.

[Marc L]

Hi,

from methods of your previous thread, you can spot on the "Page" ID and with the Count property of a collection
or you can compare displayed records from total records …

[lubbamkt]

Marc L, could you please explain a little bit more. I am looking for the number of links within id="lblPageIndex"? How should I construct the code? Thanks

Hi,

from methods of your previous thread, you can spot on the "Page" ID and with the Count property of a collection
or you can compare displayed records from total records …

[Marc L]

For example, if displayed records are inferior to total records, read next page …

[lubbamkt]

I am still confused, I tried something like

Please Login or Register  to view this content.

, but failed

For example, if displayed records are inferior to total records, read next page …

[Marc L]

Me too : « but failed », very crystal clear about error message for example !

This is a third thread for the same webpage, if you ever well explained your needs in first one !
The way you did results in wasting your time (and our !) …

So check statement in your code line where error occurs from ressource of first thread and amend it ! (bad typo)
Just create an object variable on the element ID and check in Local variables window its collections …