About Us

Don Guillett[_4_]

Send, to the address below, and I will have a look.

--
Don Guillett
SalesAid Software

"Al Eaton" wrote in message
...

Yes, I defined "a1" as a range named sym and then edited the link. It did
not work.
--

Al Eaton

"Don Guillett" wrote in message
...
Have you tried
sym=range("a1")
http://finance.yahoo.com/q/ks?s=GE
http://finance.yahoo.com/q/ks?s=" & sym & ""
--
Don Guillett
SalesAid Software

"Al Eaton" wrote in message
...
I have a web query that was created by going to a web page

http://finance.yahoo.com/q/ks?s=GE

selecting Export to Excel, then selecting the specific data I want to
download. This is the query created:

WEB
1
http://finance.yahoo.com/q/ks?s=GE

Selection=21,24,26,29,32,35,38,41,44,48,52,55,58
Formatting=None
PreFormattedTextToColumns=True
ConsecutiveDelimitersAsOne=True
SingleBlockTextImport=False
DisableDateRecognition=False
DisableRedirections=False

The problem is that this does not create a parameter query. For
example,
if
you use Microsoft's stock quote web query there is a parameter option
so
that you can easily change the stock ticker. Is there a way to make
the
above query into a parameter query.
--

Al Eaton

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Parameter Query	Lee	Excel Discussion (Misc queries)	4	October 12th 09 07:38 PM
Parameter query in MS Query from Excel	Jimbo	Excel Discussion (Misc queries)	1	September 9th 09 04:27 PM
Convert hard coded query criteria to Parameter Query	Melanie[_2_]	Excel Discussion (Misc queries)	0	July 15th 08 09:59 PM
How to choose if I use a parameter or not in a parameter query	Arnaud	Excel Discussion (Misc queries)	0	March 8th 07 01:19 PM
How to use a Access Query that as a parameter into Excel database query	Karen Middleton	Excel Discussion (Misc queries)	1	December 13th 04 07:54 PM

Menu

About Us