Automatically go to a hyperlink within a hyperlink

[Zak14]

I've got a list of movie names in column D and I use the following formula to search IMDb for the movie name in column D

=HYPERLINK  (  "http://www.imdb.com/find?q="   &D2   &"&s=all" ,   "IMDb"  )

Is it possible to make Excel go to the link of the first search result within that webpage that I am linking to.
Let's use this link as an example: www.imdb.com/find?q=Fight Club (1999)&s=all

Btw, the reason for this is so that I can retrieve real-time info from each of those pages for each movie link.
This is why I don't want excel to just select the link within the link but to automate that link before even landing on the search page.
I'll worry about the rest later.

Thanks a bunch.

 

[Zak14]

Bumpity bump

 

[Zak14]

Anyone?

 

[Zak14]

Bumpy bump

 

[John_w]

IMDB prohibits the use of screen scraping to extract data. For alternatives see web api - Does IMDB provide an API? - Stack Overflow.

 

[Zak14]

IMDB prohibits the use of screen scraping to extract data. For alternatives see web api - Does IMDB provide an API? - Stack Overflow.

Thankyou for the reply.
I have no idea of half the vocabulary these people use in these forums.
My boss says I'm really good at access and excel and whatnot but when I come to the internet, I get an idea of how much of a noob I am.
Please explain the contents of that link very briefly and I'll try figure the rest out.
Thank you.