Extract all links from a URL into a column in Excel

[Oliver Dewar]

Does anyone have a good script (or can think of one) to extract all the links from any given URL into a column in excel?

I have a version at the moment, but it downloads the page source to a text file then imports it to excel and extracts the links... seems a long way round.

I've had a good look around Google but can't see any working solutions.

Cheers guys.

 

[tyger0951]

Post what you have please.

 

[Oliver Dewar]

Thanks for jumping into this thread Tyger. My code is so long and convoluted that I'm embarrassed to post it. I was hoping that someone might have been over this territory before.