Extracting data from website

[GustavoR]

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.

Can you please help me?

 

[igold]

This is an excellent video that should shows exactly what you are trying to accomplish..

https://www.youtube.com/watch?v=iSlBE3CWg5Q