worksheet tab colors

[Claire1976]

Can you access stock quotes via Microsoft excel

 

[Juan Pablo González]

Yes, you can. Use web queries.

 

[NateO]

Even more specifically, check out the following:

http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q162080&

I particularily like:

<pre>
Sub URL_Post_Query()
With ActiveSheet.QueryTables.Add(Connection:= _
"URL;http://webservices.pcquote.com/cgi-bin/excel.exe", _
Destination:=Range("a1"))
.PostText = _
"QUOTE0=[""QUOTE0"",""Enter up to 20 symbols separated " & _
"by spaces.""]"
.BackgroundQuery = True
.TablesOnlyFromHTML = True
.Refresh BackgroundQuery:=False
.SaveData = True
End With
End Sub</pre>

If you store the symbols, the refresh is a cake-walk:

<pre>
Sub Refresher()
'where a7 is a cell in your Querytable
[a7].QueryTable.Refresh
End Sub</pre>