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 |
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 |
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 |
All times are GMT +1. The time now is 03:06 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com