Excel: URGENT - extracting data from website

Guys, i've been trying this for a long time and now i give up trying lol. i want a macro that access the website https://br.financas.yahoo.com/q?s=pmam3&ql=1 copy the value of the quote, then paste at the worksheet after that, go to the "digite o símbolo" box, search for another cote and repeat the process. I have tried the .getelementbyid, but it simply doesnt work. Can you please help me?

This question generated 15 answers. To proceed to the answers, click here.

This thread is current as of December 12, 2014.

For more resources for Microsoft Excel