VBA to scrape data from website

I am pretty new to VBA, but am trying to write a data scraper to pull information from a website and import it into an excel workbook. I had some help getting started but am coming across a few errors that I cannot figure out.

1. run-time error 1004: application-defined or object-defined error

If I comment out this error, I get to this:

2: run-time error 1004: unable to open http://... the internet site reports that the item you requested could not be found.
(But when I go to the exact same URL in explorer it opens fine.)

Please Login or Register  to view this content.

Thanks in advance to any helpers