| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to modify the web link for retrieving data from external sourc
Referring to Excel General Question
Does anyone know how to modify the web link for retrieving data from external source? such as http://www.hkex.com.hk/futures/futur...hsio070102.htm This parameter "http://www.hkex.com.hk/futures/futuresdayrpt/hsio" does not change, but this part "070102.htm" will be changed based on the current date. I cannot use indirect function under external linkage, does anyone have any idea on solving this problem? Thank you in advance Eric |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to modify the web link for retrieving data from external sourc
See my reply in GQ?
http://www.microsoft.com/office/comm...c-bc9a30ba9ad4 "Eric" wrote: Referring to Excel General Question Does anyone know how to modify the web link for retrieving data from external source? such as http://www.hkex.com.hk/futures/futur...hsio070102.htm This parameter "http://www.hkex.com.hk/futures/futuresdayrpt/hsio" does not change, but this part "070102.htm" will be changed based on the current date. I cannot use indirect function under external linkage, does anyone have any idea on solving this problem? Thank you in advance Eric |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hidden external data link | Excel Discussion (Misc queries) | |||
| sorting 2 colums of numbers and incremening them down | Excel Discussion (Misc queries) | |||
| Excel + user input + external data (URL manipulation) | Excel Discussion (Misc queries) | |||
| Inserting a new line when external data changes | Excel Discussion (Misc queries) | |||
| Using "Get External Data" | Excel Worksheet Functions | |||
Linear Mode
