Download HTML source

[theta]

Hi all...

I have been reading through another thread but it does not yield the results I am after (although I do like the DOM suggestion).

http://www.mrexcel.com/forum/showthread.php?t=325775&page=2

I need to download Bloomberg currency rates from

http://www.bloomberg.com/personal-finance/calculators/currency-converter/

It has to be this source for audit purposes. At present this is a manual process, making the required selections one by one. If you look into the source, all of the rates are there - so would like to be able to pull the HTML source into excel then I can draw out the information required

If each line break in the HTML could be translated into a new ROW into excel that would be amazing.

I only need the CDATA table which is half way down the page source :

price['ADP:CUR'] = 120.666;
price['AED:CUR'] = 3.673;
price['AFN:CUR'] = 48.14;
etc...

Any ideas?

 

[John_w]

I have been reading through another thread but it does not yield the results I am after (although I do like the DOM suggestion).

http://www.mrexcel.com/forum/showthread.php?t=325775&page=2

That code is specific to the particular web site mentioned. I wouldn't expect it to work for Bloomberg, but a similar technique using DOM manipulation with the HTML Object Library should work. You probably need to retrieve the collection of scripts using GetElementsByTagName("SCRIPT") and then search for the script containing the exchange rate data using the Instr function etc.