Download a spreadsheet with VBA
 

Hi,

I was wondering if there was a way to use VBA to download a
spreadsheet from a website and incorporate it directly into a
spreadsheet I am working on. My company has a subscription to a news
service that gives us historical earnings estimates, but using the
Import Data -- New Web Query only grabs half the table. There is a
link to a spreadsheet on the top of the website that gives all the
information I want, but I cannot figure out how to get Excel to import
that spreadsheet as well.

Jason