Movie Database macro

Hi,

I have been trying for a while to get a working link between an excel database of my movie collection and imdb.com to keep all the data up to date.

I found someone that helped and it worked, I have no understanding of macros and VBA but they made it work whereby running the macro would refresh all the data in the workbook with the new imdb data. but imdb changed something in the layout of their site and since then it won't do what it was doing.

If anyone would like to have a crack at this, feel free. I'll attach the workbook with the macro so you can either tinker around with that and find the problem or just straight out start over, whatever works.

Thanks and I hope the pointlessness of this is quietly ignored.

Hi,

It does take a long time but it leaves quite a few results blank.

Does that mean to say that it worked fine for you and pulled all the data?

the columns rating and votes are supposed to refresh and contain the current up to date data from imdb.com, but after running the macro quite a few are left blank for me, because the data that is there at the moment is erased and the new data refreshes it, but it seems that it won't pull all the titles from the website. for me anyway

any more ideas or helpers on this would be welcome