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
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