View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Setup problem for hyperlink in Excel !

You have active threads elsewhere.

Eric wrote:

Referring to the post in General Question

=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