Hi
I'm new with VB in excel and I would like to automate a web query
function to gather new data everytime I change the stock symbol. Here
are the descriptions and any hints or tips is always appreciated.

sheet #1, enter symbol into cell (C3)
copy symbol in C3
Go to sheet #2
Edit query
(http://table.finance.yahoo.com/d?a=1...&f=2004&g=d&s=)
paste symbol into box
Get data
Select entire page
Import
Go back to sheet #1

Is there a macro for this?
I am having trouble when i have to bring in the webquery.


THanks


---
Message posted from http://www.ExcelForum.com/