Extract Data from website

[vbalearner]

Hi MessageBoard Member,

Happy to link with ChandooOrg board site.

I am from Mumbai. And learning vba still. Have a query related to one of my daily task.

I have one excel sheet, which contains some unique number in col A.
Also, I have one website, from where I have to find out the details of this numbers.
website - http://www.track-trace.com/aircargo

when you will open the website, you can find one text box wherein, I have to enter my number from excel sheet. and besides to the that there is button named "Track with option".
I am trying to copy the each cell value from excel and paste it into in text box and then click on button. After clicking on the button, we will get the details about the shipment code.
I will show you the page -



Here, this is the next page. Sr no. 1 is the code which we are finding.
Sr no. 2 is the location which i need to trace out whether the shipment is arrived or not.
From, Sr No. 3 and Sr No. 4, I get to understand that the shipment are received are not. Therefore, this are the two main points I have to copy and paste it into an excel sheet.

Therefore, I request all team board members to help in getting some codes please.

Because there are daily 150 and above records I have to check daily.

I hope and believe I will get the code please.

 

[vbalearner]

Hi MessageBoard Member,

Happy to link with ChandooOrg board site.

I am from Mumbai. And learning vba still. Have a query related to one of my daily task.

I have one excel sheet, which contains some unique number in col A.
Also, I have one website, from where I have to find out the details of this numbers.
website - http://www.track-trace.com/aircargo

when you will open the website, you can find one text box wherein, I have to enter my number from excel sheet. and besides to the that there is button named "Track with option".
I am trying to copy the each cell value from excel and paste it into in text box and then click on button. After clicking on the button, we will get the details about the shipment code.
I will show you the page -

View attachment 32418

Here, this is the next page. Sr no. 1 is the code which we are finding.
Sr no. 2 is the location which i need to trace out whether the shipment is arrived or not.
From, Sr No. 3 and Sr No. 4, I get to understand that the shipment are received are not. Therefore, this are the two main points I have to copy and paste it into an excel sheet.

Therefore, I request all team board members to help in getting some codes please.

Because there are daily 150 and above records I have to check daily.

I hope and believe I will get the code please.

Any one is there to help??

 

[Marc L]

Hi !

Welcome on this forum !
Your initial post is incomplete !
You tried to explain a case but for sure there are another cases …

Your need is not special to VBA but requires Internet and HTML skills !

And on Excel side, as written in third direction of the blue rollin' banner
before to log in or just read the tip under this post just above
the answer frame !

See Web Scraping tutorial …
​

 

[vbalearner]

Hi !

Welcome on this forum !
Your initial post is incomplete !
You tried to explain a case but for sure there are another cases …

Your need is not special to VBA but requires Internet and HTML skills !

And on Excel side, as written in third direction of the blue rollin' banner
before to log in or just read the tip under this post just above
the answer frame !

See Web Scraping tutorial …
​

Thank Mac for your suggestion and notification.
I will find my own.

Some people don't understand the query and makes likes on post. For them improve the knowledge and make the action then..

 

[Marc L]

Likes on post means people agreed with it :
before to code anything, we need a crystal clear explanation !

Have you ever read the third message of the blue rollin' banner before
to log in or just the tip frame just above the answer box ?

I can't waste time on a code and receive an answer like
"It's not like this I want the data" or "I forgot to tell …"

As coding needs logic, so when things are missing,
we can do nothing except to post a link on a close subject …

See also the samples of the threads of this forum like

Copy data from a website to excel

Get data from web site

IE Java Script and Excel scraping

Capturing Web Data as per the Financial Year …
​

 

[Marc L]

Any news ?!
​