Excel Web Query browser must have javascript enabled

I am trying to perform an excel web query on the very excellent FantasticFiction.co.uk books website - for purely non-commercial reasons (I want to be aware of new books coming out). The website uses javascript to create tables. The web query gives me a message saying:

"Sorry, the browser you are using must have javascript enabled in order to see this page"

I have searched for solutions on a variety of websites, and not found anything that I can make work. Does anybody have an example?

Here is the code I was using:

Please Login or Register  to view this content.

So I have searched all over the web for options. Concluded that the javascript makes web query unworkable.

Tried more than 20 different options, including web scrapers and too many complications to remember.

Eventually found this very simple copy/paste code in Ozgrid, courtesy of JerryD in 2007 - to whom many thanks, because it works!

Please Login or Register  to view this content.

I used the code with another URL: http://www.macauslot.com/slot/html/result/livescore.htm with you code.
Error occurred @ Loop Until contentDiv.getElementsByTagName("TABLE").Length > 0
Please help. I tried to access the web getting some scores directly into my Excel 2003 worksheets

Thanks for your help in advance...

OK. Thanks...

Originally Posted by Chippy

Try this. But first you must set a reference to Microsoft HTML Object Library in the Tools - References menu in the VBA editor, otherwise it won't work.

Please Login or Register  to view this content.

Please advice how you figure out using the tag "ffcontent" as the getElementById ???
Thanks...