View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] Bolt.Jason@gmail.com is offline
external usenet poster
 
Posts: 1
Default 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