| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel,microsoft.public.excel.links,microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.querydao
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Parameter Query | Excel Discussion (Misc queries) | |||
| Parameter query in MS Query from Excel | Excel Discussion (Misc queries) | |||
| Convert hard coded query criteria to Parameter Query | Excel Discussion (Misc queries) | |||
| How to choose if I use a parameter or not in a parameter query | Excel Discussion (Misc queries) | |||
| How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) | |||
Threaded Mode
