Setup problem for hyperlink in Excel !
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 |
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 |
All times are GMT +1. The time now is 11:14 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com