Does anyone know if it is possible to automatically import data using Excel or to create a macro that will do the same thing? I want to import share market prices for different companies into Excel so that I can create my own charts. I have used the Get External Data From Web function in Excel 2007, but I can't get it to select the table I want from the web page.