If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Convert to a Parameter Query
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 |
#3
|
|||
|
|||
Convert to a Parameter Query
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 |
#4
|
|||
|
|||
Convert to a Parameter Query
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 | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Parameter query from mulitiple fields | Kelly | Running & Setting Up Queries | 4 | June 21st, 2004 06:20 PM |
Parameter Query Help | mark | Running & Setting Up Queries | 4 | June 2nd, 2004 04:40 PM |
Using a query with a replaceable parameter as the source of a control | Hoo | Using Forms | 2 | May 30th, 2004 09:43 AM |
Using a query with a replaceable parameter as the source of a control | Hoo | Running & Setting Up Queries | 1 | May 30th, 2004 07:07 AM |
Parameter Query on date using MS Query | Brian | Links and Linking | 0 | January 27th, 2004 08:05 AM |