"John Wilson" wrote in
:

Richard,

Why don't I have Excel VBA specific help info
There is no such thing. VBA is Visual Basic for Applications.
Excel is one of those "Applications"

your syntax error.
Your VBA Tools/Options are probably set to "Require Variable
Declaration" (which is a very good idea). Having this option selected
will place Option Explicit at the top of every module (which means
that all your variables
will have to be declared or you'll get an error).
I don't know what code Don gave you, but if you delete that top line
(Option Explicit), it should work. Better though would be to find
what variables that Don was using in the code he gave you and
declare them with a Dim statement.

John



Why don't I get context sensitive help for Excel objects. When I write
Outlook macros I am able to hilight "MailItem", for example, and get
help for that particular object. It's not working for me with the Excel
Macro that Don gave me (posted below)





X = [quotes!a65536].End(xlUp).Row
For Each c In Sheets("quotes").Range(Cells(5, 1), Cells(X, 1))
symbols = symbols & "+" & c
Next

URLAddress = "http://finance.yahoo.com/d/quotes.csv?s="
mystringend = symbols & "&f=snd1t1l1ohgpv&e=.csv"
qurl = URLAddress + mystringend
With Sheets("Data").QueryTables.Add(Connection:="URL;" & qurl, _
Destination:=Sheets("Data").Range("b2"))
.BackgroundQuery = True
.TablesOnlyFromHTML = False
.Refresh BackgroundQuery:=False
.SaveData = True
End With