Thank you for your suggestion

It seems to me when I put your given code into the link, the page cannot be
able to loaded, because some communication setting are required, could you
please give me any suggestion on how to setup this setting?
Thank you very much
Eric

"JLatham" wrote:

Try this - it's all one formula:

=HYPERLINK("http://www.hkex.com.hk/futures/futuresdayrpt/hsio" &
RIGHT(YEAR(NOW()),2) & IF(MONTH(NOW())<10,"0" & MONTH(NOW()),MONTH(NOW())) &
IF(DAY(NOW())<10,"0" & DAY(NOW()),DAY(NOW())) & ".htm","View Todays Updates")

"Eric" wrote:

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