Convert to a Parameter Query

A

Al Eaton

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.
 
A

Al Eaton

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Web Query problem 1
How to use symbol=["Ticker" "Enter ticker"] with Microsoft Excel 2 1
Series of web queries: Autofill? 1
Run .IQY within VBA 0
Web Query, Help! 1
VBA: Delete name range 3
IQY File: Invalid Web Query 2
Web Query address parameter 2

Top