I have downloaded the below code from a website (Sory i can't remember name of the site) while i searching for the method to scrape website data using xpath. However this code gives Runtime error 91 & debugging shows the line 
Please Login or Register  to view this content.
I have enabled Microsoft internet controls, Microsoft HTML object library & Microsoft XML v6. My Version of excel is 2010.Could yolu please let me know why i'm getting this error.
Code
Please Login or Register  to view this content.