download and set table in excel from web that uses Java script

I am working with this website (http://www.hkexnews.hk/sdw/search/search_sdw.asp).
After I entered stock code, for example 00005, the page jumps to another, but with the same website (http://www.hkexnews.hk/sdw/search/search_sdw.asp) (I don't know if this is the result of JAVA script). What I am looking for is the table in the second page (i.e., after I entered the stock code). Please help

Marc L, did you take a look at this website (http://www.hkexnews.hk/sdw/search/search_sdw.asp)? I cannot apply the previous 3 methods to download a web table. I dont know if this is due to this website is using JAVA script.
Based on my shallow understanding of VBA, I guess this time the problem has nothing to do with WAIT.

Originally Posted by Marc L

Hi,

as in your previous threads you already had 3 methods to download a web table,
with IE just try Wait method (just see in VBA help !) until table is loaded …

as I said in post #1, the web table data was downloaded into excel in a few cells in one column. I DID try to use methods I learned from previous threads to map the rows and columns of web table into array, but I cannot success.

Please Login or Register  to view this content.

this is what I used to try to map the rows and columns of the web table, but I found the rows.length is JUST 13 (I also attached a demonstration file in post#1 - refer to the first worksheet), but the rows of the web table should be >200. This is what I am facing now.

At this time your link doesn't work anymore (site problem)
but when I inspected webpage it seemed that the table to load hadn't an ID !

Edit : it's your post #4 link which is bad ! First Ok …

So the data are in another table inside the table with ID …

Maybe better is to use a clipboard (copy / paste) like I did in one of your previous post, could be done in IE too …

I am using below code to get the result in the first worksheet of attached demonstration file. As you see the red code, this is what I GUESS the ID for the table. (I am not sure because my vba skill is very insufficient, that's why I am seeking help now). If this is in "normal" HTML format (I dont know if I describe it correctly), I could apply the knowledge from previous threads. But they are seemingly using another format so that I cannot make use of the knowledge from previous threads.

I hope you can understand my situation.
What result I would like to achieve is like simply copy the web table and paste it into excel (just like the second worksheet of the attached demonstration file) so that each cell carries only one value.
Thank you once again

Please Login or Register  to view this content.

Originally Posted by Marc L

At this time your link doesn't work anymore (site problem)
but when I inspected webpage it seemed that the table to load hadn't an ID !

Edit : it's your second link which is bad ! First Ok …

So the data are in another table inside the table with ID …

Maybe better is to use a clipboard (copy / paste) like I did in one of your previous post, could be done in IE too …

I had also thought if it is possible to search <TR> and <TD> within ie.document.getelementbyid("tbl_Result_inner") to map the rows and cols of the web table. But I cannot identify the numbers of <TR> and <TD> in ie.document.getelementbyid("tbl_Result_inner"). Feeling shy to ask too many questions here. Sorry

I just saw in your code READYSTATE.READYSTATE_COMPLETE is not defined, could never work like this …

I can use getElementsByTagName("TABLE") (12) to see the table data, but the whole table is saved in one cell. Now I had 2 questions.

1.) when run to the second code

Please Login or Register  to view this content.

"Run-time error '424': Object Required" happened

2.) I checked with Locals Windows and found ie.document.getElementsByTagName("TABLE")(12) only got 1 row, how could I map the rows and cols of the web table?

Originally Posted by Marc L

The table ID "tbl_Result_inner" is not the table with data ! Just check with webbrowser inspector tool …

From this ID, you could use getElementsByTagName("TABLE") to get a collection of tables within this table ID
and check which element is the table you are looking for …

But if you need also data above this table (starting with Detail of Market), easier is to use clipboard method.

Marc L, are you 100% sure that the table does not exist and occur error 424 is due to undefined READYSTATE.READYSTATE_COMPLETE ?
I got the following in another module.

Please Login or Register  to view this content.

Originally Posted by Marc L

What's the value of READYSTATE.READYSTATE_COMPLETE in your code ?
While not fixed, code will never work …
It's why you get the error 424 : table does not exist 'cause the page is still loading !

Thx Kyle123, I found a bit difficult to use a static URL because the website provided is not the ultimate web page to download the web table. I need to enter a stock code and click search button. After I reach the next page, I found that the URL is the same as the previous web page. So I don't know how to use your code.

[/LEFT]

Originally Posted by Kyle123

This can be made more efficient, but it's a starter for 10, will need adapting as necessary:

Please Login or Register  to view this content.

Amazing! It works perfectly, how should I amend the code if I want to change another stock code? How could I set the stock code as variable so that I can change it by,say, input box?

Originally Posted by Kyle123

Did you try my code?

Originally Posted by Kyle123

This can be made more efficient, but it's a starter for 10, will need adapting as necessary:

Please Login or Register  to view this content.

Hi Kyle123,

I know this is a bit older question that you helped.

Recently, I found the website has changed a bit (adding a hidden input data

HTML Code: 

whose value changes every time I send information to the server) so that I cannot use the solution you offered to me.

Could you tell me the way to overcome this difficulty? Please