Import web data in Excel cell using VBA. Excel 2003

**Francisco Sousa** · 03-12-2015, 08:47 PM

Excel 2003

Hello,

I would like to parse data from a website and paste the value in Excel cell. For example from the site, "http://www.euro-millions.com/results" I want to get the string "Next Estimated Jackpot value." and the amount 15.000.000,00.
Any thoughts or code would be much appreciated.

Regards,
FS

**AB33** · 03-13-2015, 06:13 AM

The code works on the site, but I do not know how the currency is picked if you are to access it from Portugal.

**Francisco Sousa** · 03-14-2015, 11:13 AM

Hello,

I want to thank you for solving the proposed problem and apologize for just now thank you.
I have another question to ask, how to search other tags in addition to the "title", such as a "div" with "getElementsByClassName"
By the way, the symbol of the currency used in Portugal is the euro "€", because we belong to the European Union.

Many, many thanks.

Best Regards,
FS