Extract Table data from web page to excel

Hi All,

i am need of help in below query.

query is, i have some list of ID and each id need to paste on website click on submit and will reflect table and that table need to paste in excel.

Note: Main page of entering number and clicking on submit that URL and after submitting of whatever page reflect that URL both are same

i have written the below code, however which i facing are below

scenarios

1. its works fine when i do manually means step by step by pressing F8, if i run at once by pressing F5, its not capturing data.
2. its works fine when i do manually means step by step by pressing F8 or by pressing F5, but at "getelementbytagname" line its giving as "Object variable not set", and we click on debug button and after pressing debug button , if i press again F8 its working.

why this happening im unable to understand, below is my code.

Note: Sorry i cant provide the website link as its very sensitive.

Please Login or Register  to view this content.

Hi there,
I don't have any experience with getting data from web using macro, so I am not the right person to guide you.
However, I am not getting any error using the above macro when I press F5. It just shows "Process Complete" in the message box. No error is shown.

Hi Sourab,

thank you for looking my query,

however it will not show any error to you, as path is taking from excel file.

as i mention continuously, its not showing error, some time showing and some time not and sometime data capturing and sometime not.

the reason for not capturing data is main page URL and after submitting what ever page load that URL both are same , hence sometime its capturing data from main page and sometime from after page load.

Hi All,

can any one please help me out with this, how to encode this..

OK, even without the URL i think that maybe the below code might work. Please try it and let me know if it worked or not. I am assuming that somehow you are losing handle of the IE window so the modification i have made to your program should get again a handle over the IE window. You will need a reference to the Microsoft Shell Controls and Automation library.

Please Login or Register  to view this content.

Hi EduardoHiguchi,

Thank you for quick response on my query, almost i spend more than 5 hours of time to get it done.

i have test on around 5 rows of data and its works well.

today i will test on around 600 ID's then after i will let you know...

anyhow you have save my lot of time, i know its main page URL sometime and sometime after clicking button page and i dont know how to overcome with this and you have done it.

Thank you So much ! , i will get back to you today EOD.....

Hi EduardoHiguchi,

i have test on huge rows, however sometime its closing the browser and sometime not, due to this for multiple rows its pasting same data.

to avoid this i made small changes, i moved below line at initial and its works well thanks alot buddy...

Please Login or Register  to view this content.