Having problem to import tabular data from webpage to excel

I am trying to import tabular data from web pagehttp://nepalstock.com.np/floorsheet to excel. This web page gives option to view 500 rows of data at a time. When I try to import this table using "get external data" from Data tab in excel, it only imports first 20 rows of data. There are more than 15 pages of data. Is there any way to import entire table at once without having to navigate to next page.

Hi
Try to use the following code VBA (modify the start and end page as needed)
(Use a empty Sheet as active sheet)

Please Login or Register  to view this content.

Thank you so much. I will check and revert if it works.

I am getting "Invalid Next control variable reference" error. How can I resolve this ? As I have very little idea about VBA I would really appreciate your help

Hi
It works for me. I'm sorry. I change var i with var page. So, use
Next Page

Hello

Thank you so much for the code. It works fine but can we modify code to get 500 rows of data at a time ?
As this code imports only 20 rows of data at a time and there are more than 380 pages it takes lot of time to import all the data. However, the webpage gives option to view 500 rows of data at a time.
I would really appreciate if you could solve this issue.

Regards,

Yugadi

what do after entering this code?