View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JLatham JLatham is offline
external usenet poster
 
Posts: 3,365
Default 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