• 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.

question

S

stefanoste78

Member
Good evening,

I have a question to ask.

Based on your experience, with a macro, is possible to extract all the emails and the external links of the site?

Thank you
 
Hi, stefanoste78!
Could you please elaborate? It's not clear what you're trying to achieve. A site doesn't have emails account, except of those explicitly displayed on its pages. If you refer to the email accounts of the domain, the answer is no.
Please post a sample target site. Avoid targeting NSA, GCHQ, FSB and co.
Regards!
 
SirJB7 said:
Hi, stefanoste78!
Could you please elaborate? It's not clear what you're trying to achieve. A site doesn't have emails account, except of those explicitly displayed on its pages. If you refer to the email accounts of the domain, the answer is no.
Please post a sample target site. Avoid targeting NSA, GCHQ, FSB and co.
Regards!
Click to expand...

Hello.
To make you understand better, I've attached emails and links from www.uniba.it.
I used two scrapping programs to extract both. I would like to see if these two extractions can be made with the macros / VBA language.
Thank you
https://www.dropbox.com/s/jrvxss8iqblnnfk/external_all.xlsx?dl=0

https://www.dropbox.com/s/vzwpr910wbinek2/email.xlsx?dl=0
 
Hi, stefanoste78!
Thanks for the uploaded files, they're very clear for understanding your requirement.
It can be done, but I'm wondering why doing it via VBA or any other method when there is yet a simple working way via those scraping programs?
I don't think you're gonna walk around the world crawling web pages to extract email accounts, are you?
Regards!
 
SirJB7 said:
Hi, stefanoste78!
Thanks for the uploaded files, they're very clear for understanding your requirement.
It can be done, but I'm wondering why doing it via VBA or any other method when there is yet a simple working way via those scraping programs?
I don't think you're gonna walk around the world crawling web pages to extract email accounts, are you?
Regards!
Click to expand...

Scrapping programs work for one url at a time. With macro maybe you can act on multiple url at a time. Right?
Then with a macro I can automatically organize the emails as I would like to do with these programs I have to do different steps to do so.

I ask you:
Assuming you have an infinite number of url in column a (from cell a2 onwards), you can extract, in the column cell "b" at the cell where the url is located, all the site euams separated by a Comma in the column cell "c" the number of emails in the site in the column cell "D" all the external links separated by a comma and the other columns extract the emails according to the criteria?
Thank you
 
Hello guys.
I found the macro that counts the emails and orders them.
Now it's up to you to set the code to extrapolate all the eals from the site. You must enter the column of websites in the file from which the macro will need to extrapolate emails.
Force that you can get a nice result ..
See you soon
 

Attachments

  • EMAIL.xlsm
    16.8 KB · Views: 1
You must log in or register to reply here.
Back
Top