Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
Excel 2007 Beta Setup Problem | Setting up and Configuration of Excel | |||
Excel 2000 problem copying drawingobjects between sheets | Excel Discussion (Misc queries) | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
Problem Opening An Excel file. - by yk | Excel Discussion (Misc queries) |