• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

404 url checker and download customer details

R

rowkan.mondal

New Member
Hello there.

I have a url list example (https://www.whitepages.com.au/a-720010001R) where (https://www.whitepages.com.au/a-) remains constant and the code (720010001R) at the end changes.
Now i want a macros where i can check all the links and only the links which have data (refer to attachement 1) i want to download the data like (Name, Address, Phone number) in the columns (B,C,D). Where the links remain in column A. The links which do not have data (refer to attachment 2)the column (B,C,D) remains blank.

I will be attaching a excel file with 50 link for reference.

Note the urls which do not have data also shows 404 message when clicked in excel sheet.

Thanking in advance
 

Attachments

  • attachment 1.jpg
    attachment 1.jpg
    196.7 KB · Views: 5
  • attchment 2.jpg
    attchment 2.jpg
    138.9 KB · Views: 4
  • url example.xls
    29.5 KB · Views: 2
Last edited:
rowkan.mondal
As a new member, could You reread..

Site Rules - New Users - Please Read

Hi all, Welcome to the Chandoo.org Forums. Posting Rules & Etiquette The Chandoo.org Forums is a collaborative and happy place to learn and expand your Excel knowledge. The Chandoo.org Forums consist of several Sub-Forums based on the type of question/area of Excel you are interested in...
chandoo.org
How to get the Best Results at Chandoo.org
Your comment Its kind of urgent... ... hmm?

Hints:
Is there something more, which You would write .. about Your thread?
Have You tried to search something same from Chandoo.org?
 
vletm said:
rowkan.mondal
As a new member, could You reread..

Site Rules - New Users - Please Read

Hi all, Welcome to the Chandoo.org Forums. Posting Rules & Etiquette The Chandoo.org Forums is a collaborative and happy place to learn and expand your Excel knowledge. The Chandoo.org Forums consist of several Sub-Forums based on the type of question/area of Excel you are interested in...
chandoo.org
How to get the Best Results at Chandoo.org
Your comment Its kind of urgent... ... hmm?

Hints:
Is there something more, which You would write .. about Your thread?
Have You tried to search something same from Chandoo.org?
Click to expand...
I did but i am just lost.

I am really sorry about that comment (Its kind of urgent...).

If i could get n answer it would be much appreciated...

thanking in advance.
 
You must log in or register to reply here.
Back
Top