Home |
Search |
Today's Posts |
#1
|
|||
|
|||
CELL function within HYPERLINK
Can I use a CELL function for extracting a workbook name for further
using in the HYPERLINK function. Something like this HYPERLINK("[CELL("filename")]June!A1"). It is always gives an error or jsut build a wrong link. Thanks |
#2
|
|||
|
|||
The problem is the [ & ] and worksheet name that gets brought in.
Try this =HYPERLINK(SUBSTITUTE(LEFT(CELL("filename",[data99.xls]journal!A1),FIND("]", CELL("filename",[data99.xls]journal!A1))-1),"[","")) -- HTH RP (remove nothere from the email address if mailing direct) "VadimGor" wrote in message ups.com... Can I use a CELL function for extracting a workbook name for further using in the HYPERLINK function. Something like this HYPERLINK("[CELL("filename")]June!A1"). It is always gives an error or jsut build a wrong link. Thanks |
#3
|
|||
|
|||
Thanks,
it works fine with excel saved on the disk. I still falling into original problem, when an excel report opened from WEB. The file saved in the "Temporary Internet Files" and a name is changed from "report_XXXX.xls" to "report_XXXX[1-N].xls". Excel raise a security warning concerning a document referenced to an internet space, either it treats a name as report_XXXX(1-N).xls. Any ideas, how possible to get a "clean" workbook name ? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I obtain the address of a cell using the vlookup function? | Excel Worksheet Functions | |||
clock | Excel Worksheet Functions | |||
Hyperlink a word within a cell | Excel Discussion (Misc queries) | |||
Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
Extract hyperlink string from excel cell | Links and Linking in Excel |