Setup problem for hyperlink in Excel !
 

=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")

As I try to input above code into web link for external source, the page
cannot be
able to loaded, because some communication setting are required, does anyone
know how to solve this communication setting?
Thank you for any suggestion
Eric

Setup problem for hyperlink in Excel !
 

You may want to explain what "communication settings" are.

And you have more responses at your original thread.

Eric wrote:

=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")

As I try to input above code into web link for external source, the page
cannot be
able to loaded, because some communication setting are required, does anyone
know how to solve this communication setting?
Thank you for any suggestion
Eric

--

Dave Peterson