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.
Hello Endlin3,
Welcome to the Forum!
What is the macro not doing that it was doing? Besides taking a long time to complete, it is logging data to the worksheet.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
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?
Hello Endlin3,
It is difficult to say if it ran correctly, since I have no example of what the data should look like afterward. Do you have an example of what the final data should look like?
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Star3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
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
to see what was copied find the line
Sheets("Query").Delete
put a ' in front
'Sheets("Query").Delete
this will stop the sheet being deleted run the code then see whats on it
Mojito connoisseur and a dabbler in Cisco
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks