Macro To Copy Specific Data From Website

fiberboysa

Board Regular
Joined
Apr 25, 2012
Messages
106
Office Version
  1. 365
Platform
  1. Windows
Hi Dear All,
This is the website showing results of an employment test (http://nts.org.pk/Test&Products/Results/082017/EmoOldAgBenIst_18200817_Result/Search.php). I want to know my position in the result. So I started to search for a macro to do it and this is what I found. https://www.mrexcel.com/forum/excel-questions/508733-macro-website-copy-paste-into-excel.html

Now referring to the above thread I want to modify this macro so it can put the Roll Number in the required field and than copy paste result in excel file. I know we need to put that code as well to get the result. But trick is that if you check a result and than Click on "Back" button the code remains same i.e. you can again enter the Roll No. and get another result and so on.

For instance a random Roll No. is 33250357. You can check it and continue the series to get more results.
 

Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce

Forum statistics

Threads
1,224,823
Messages
6,181,181
Members
453,021
Latest member
Justyna P

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top