Dynamic Web Query

Hello,

I've been trying to make a dynamic web query to pull stock info from yahoo finance. I want to type the stock symbol into a cell and have all its info come up below it.

I've tried the guuide posted here: http://blogs.msdn.com/excel/archive/...b-queries.aspx

Instead of using the msn, i used:

activecell.QueryTable.Connection="URL;http://finance.yahoo.com/q?s=[""Ticker""]"

However, when I hit enter, I get a Runtime error 1004. Am I doing something wrong?

Hm. The beginner portion was taken out of my title. So, just so you all know, I have no idea what I'm doing when it comes to this stuff. Please help me out.