| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Web Query address parameter
I've created a Web Query that retrieves information about a certain stock.
Instead of modifying a parameter in the web query address when I want to select a different stock, is there a way to insert the text from a cell on the spreadsheet? example: http://finance.yahoo.com/q?s=ibm gets me IBM. Can the parameter "IBM" get input by the user or selected from a cell (say +a10)? Thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Web Query address parameter
try
s=&[a10] or s="&[a10] If you are doing this by code, pls post your code here (Do NOT attach workbook) "buckle" wrote in message ... I've created a Web Query that retrieves information about a certain stock. Instead of modifying a parameter in the web query address when I want to select a different stock, is there a way to insert the text from a cell on the spreadsheet? example: http://finance.yahoo.com/q?s=ibm gets me IBM. Can the parameter "IBM" get input by the user or selected from a cell (say +a10)? Thanks |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Web Query address parameter
Many thanks to Don and Haldun. I'll give your suggestions a try.
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 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) | |||
| Web Query address parameter | Excel Programming | |||
Linear Mode
