PDA

View Full Version : How to format a part of the imported table from Web



guatelize
06-09-2011, 08:04 AM
Hello

I've downloaded from Kbase the file Get_HTML_Table :

http://www.vbaexpress.com/kb/getarticle.php?kb_id=576

It works very good, but I need only a part of the imported table, to be auto-refreshed, from the European Central Bank website :

http://sdw.ecb.europa.eu/quickview.do?SERIES_KEY=143.FM.M.U2.EUR.RT.MM.EURIBOR3MD_.HSTA

I attached a workbook with the imported data in sheet 1 and the desired format in sheet 2
:help
Thanks for your help