fiberboysa
Board Regular
- Joined
- Apr 25, 2012
- Messages
- 106
- Office Version
- 365
- Platform
- 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.
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.