Scraper working with IE9 but not IE10 (Mid VBA?)

Hey Guys,

I've developed a spreadsheet that takes a list of Amazon URLs, and returns the product title, price, and whether or not it is in stock. I'm using the InternetExplorer.Application Object.

The attached sheet works perfectly with IE9. The title and price functions don't work with IE10.

From testing, it appears that the Mid functions in the VBA code aren't working with IE10.

Any idea on how to fix this? (and hopefully make it work universally?)

Thanks!
MattAttachment 271542

hmm, so I just tried it on my friend's laptop with IE10 and it worked.

So it's 1/1 with IE9, 2/4 with IE10

Don't mean to keep updating this, but seems to be completely independent of the version of IE.

So, here's the real question:

Does anyone know how to fix the 'Mid' function in VBA working on some computers and not others?