No, you use the local window to see how to call up the contents of the table you want.

That is, document.all("hbxx_hbh "). Value? =? " CZ6357 "

That is, document.all("hbhcx "). click

What time? ie.readyState？ & lt& gt？ four

Multiple activities

line

Apply. Wait? (now ()? +? TimeValue("00:00:05 ")' is delayed for 5 seconds (you can try the shortest few seconds to achieve fast and accurate), otherwise you will get" no information for the time being ",and the response of the database server is not as fast as that displayed on the web page.

Sheet 1。 Cells (3,? 3)? =? Namely. Documents. All ("TRS"). The sentence' innertext' obtains the information content inquired by the flight.

Sheet 1。 Cells (3,? 3)? =? ie.document.body.innerText？ Get all the contents of the main body of the web page, and then use split? +? After array shaping, satisfactory typesetting can be obtained. I have tested that the code above is ok. The core problem is to delay the data for a few seconds, otherwise the data obtained will be wrong.