View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ted Metro Ted Metro is offline
external usenet poster
 
Posts: 29
Default Import Data -- External Web Query

I'm trying to grab the table of CD rates at this website --

http://home.ingdirect.com/products/p...asp?s=OrangeCD

I can select the table with the external web query, but when it drops the
data into Excel the APY and Effective Date are not populated. Looking at the
source code it looks like the page is grabbing a string of predefined values.

Is there an easy fix to this so that I can have a web query that upon a
refresh grabs this table?

Have a good day,

Ted