Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
Hello Everybody
I have been trying to retrieve information from the Web by using a Web query, and then inserting the information into an active worksheet in Excel 2000. In the "Returning External Data to Microsoft Excel" dialog box I want to use the Parameters button, which is not active, Could anybody tell me how to activate the Parameters button before using the "Get the value from the following cell" option button? Thank you in advance. |
#2
![]() |
|||
|
|||
![]()
Hi.
It is possible to supply parameters to a webquery. You can do it programmatically as described in this KB article: http://support.microsoft.com/?kbid=213730 I don't know how to activate webquery parameters via the User Interface. -- Rob van Gelder - http://www.vangelder.co.nz/excel "Almamba" wrote in message ... Hello Everybody I have been trying to retrieve information from the Web by using a Web query, and then inserting the information into an active worksheet in Excel 2000. In the "Returning External Data to Microsoft Excel" dialog box I want to use the Parameters button, which is not active, Could anybody tell me how to activate the Parameters button before using the "Get the value from the following cell" option button? Thank you in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Query of External Data | Excel Discussion (Misc queries) | |||
Microsoft Query Help | Excel Worksheet Functions | |||
New web query with Excel Pro Edition 2003 | Links and Linking in Excel | |||
How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) | |||
Editing MS Query | Excel Worksheet Functions |