Hi, i'm a translator and also a new learner to VBA. The following website has lots of useful terms (English to Chinese) to my job, and I want to collect them to a excel file, so I can use them in my translation assistant application. I tried to use the function of importing data from a web page in the "Data" tab on the menu of Excel, but there are numerous pages and I have to click the "Next list" button each time i import a list. I'm also learning VBA now but so far I just know some basics, and inspecting the source code of a web page for find a way is another hurdle for me.

Can any one help me write VBA codes to scrape all the terms (each has five columns) from A to Z, including the hyperlinks of the headwords? I will learn the successful codes and apply them in other similar cases.

http://www.legislation.gov.hk/eng/glossary/homeglos.htm

PS: i cannot find the next list button in the source code of the webpage.

Thank you very much!