Web Query and Page Source - Importing Data

**exc4libur** · 03-27-2011, 11:59 PM

Hi,

Im trying to import a table from this URL: [url]http://www.bmfbovespa.com.br/cias-listadas/titulos-negociaveis/BuscaTitulosNegociaveis.aspx?Idioma=en-us[url]http://www.excelforum.com/excel-programming/

Stocks Traded Table...

However, it returns blank.. I looked at the page source (attached) and found the table inside! But, how am I going to manage pasting this table on excel using vba??

Rgds

Please Login or Register  to view this content.

**exc4libur** · 03-28-2011, 02:22 PM

I saved the page source from "stocks traded" as HTML, I found the table and all.. Now is there a way to import it by vba?? Via Page source coding or Query..??

Anyone??

Rgds