Automate Scraping of Hyperlinks from Web Pages Using Excel VBA

How to scrape hyperlinks in a web page automatically using Excel VBA.
Details and sample file available at this link:

[sterlingberbe]

Great stuff! Would using HasData make scraping hyperlinks easier in Excel VBA projects? Anyone tried this approach?

[pulloniyil]

I love this excellent VBA code. I also wonder if there's a way to scrape all the video URLs from a playlist / YouTube channel. Because whenever I open a YouTube video
list, all the video links are not displayed until I like click 'Load More' button in the webpage. Your help is highly appreciated.  

[MrCriminal]

I was wondering if you could help me out with a problem i have had. I'm for the moment doing all this by hand and it’s taking all lot of time and i don't even know if this kind of things is possible to write a VBA Code for. But I’m going to explain my problem.


I have an Excel sheet with important data on. All the data is in the first Sheet and always under a header for each columns. And every row is divided up for different items (Look at example 1)


Is it possible to make the VBA to extract all the data on for example cell 2A to 2Q and just paste it on a empty MS Word sheet. And add each header in front of the data extracted (Look at example 2) and then just continue to the next row and keep on doing this but on a new sheet.


And if it’s possible to always have each of the data extracted on the same place for example Cell 2A is always on the first row in the word sheet, and cell 2B is always on third row in the same word sheet  


And just let it loop throe 5.000 different rows and making 5.000 sheets in one word document 



**Exempel 1**




    Fruits (Header 1)   |   Color (Header 2)        | How many  (Header 3)   |
    
    Apple  (Row1)       |       Green               |      Three              |
    
    Orange (Row2)       |      Orange               |      One                |







**Example 2** 



Fruit: Apple 

Color: Green

How many: Three 

(Open new sheet and loop throe next row)


Fruit: Orange 

Color: Orange 

How many:One

(Open new sheet and loop throe next row)





Take a look at it, Thank you very much for taking time reading this, I’m thankful for all help and feedback on this.

[stevenrojas]

hi, can you help me, i want to know, how i can get the value of two combobox that are connect ?

[avinashkhanna]

Dear sir, can you tell me how to do automatic hyperlinks and bookmarks from 100 of word files to create ebook. It will be too difficult to create them page by page manually.

[MyTechOnlineSupport]

How to can I click on the tag to open modal popup. I am trying to autofill data in a web modal form using excel vba but there is no id, no name, no classname.
The link is like:
<a href="javascript:void(0);" data-toggle="tooltip"

Please help, it's like very urgent.

[jacobstromburg]

What if I had a hyperink in a cell (not the text in the cell, but the hyperlink that is assigned to the text). I want to navigate to whatever the hyperlink is in the cell. Is there a way to do that? I'm using ie.navigate activcell.hyperlink but it doesn't work. I can use selection.followhyperlink but then it uses the default browser which i dont want to do.

[cre]

How would you go about retrieving links from a table only. To avoid getting the other random links? Thank you

[pankajmahajan]

I need to Scrape all the download links from sourceforge website .Please Help.

[georgegt]

Dear Dinesh

First thank you very much for this useful post
I tried to run your code unsuccessfully.

Problem : InternetExplorer Object-defined not defined

Thanks in advance
 

[fazalmotiwala]

hiii Dinesh, i want to open a hyperlink using macro which is there in perticular cell in excel file. can you pls help me out on this? 

[neodiy]

Is it possible to scrap data from hyperlink instead of scrapping the hyperlink itself its a waste of efforts

[mrgaint]

Hi Sir, Awesome Code.
I have the same request for the intranet site (SharePoint Based site), this code is not working for the intranet site, please help me to run this code for the intranet site as well
Thanks a lot in advance

[mukundwagh]

Sir i am a getting syntax error at first line itself.I copied code

[kayepatrick]

need help, if i use a specific website, i get error Object invoked has disconnected from its clients.

[georgegt]

Dear Dinesh

I found it 
Before run the code make sure that MS Library HTML and MS Internet Controls are checked in Tools References  

[pankajmahajan]

Hi Sir,

When I 'am Using This Code its giving Syntax error at 1st line. Can You please help why this is happning

[virendrasinghbhanu]

Text is not visible clearly. So its not readable. Please check the video resolution.

[sagarmithra]

HAI i would like use click url how can i do

Click here to edit Application"

<a style="font-weight:bold; font-size:16px;" href=my website">Click here to edit Application Details</a>