新建兩個名稱

FileName :=MID(CELL("filename"),FIND("[",CELL("filename"))+1,FIND("]",CELL("filename"))-FIND("[",CELL("filename"))-1)

SheetName :=RIGHT(CELL("filename"),LEN(CELL("filename"))-FIND("]",CELL("filename")))


hyperlink的語法
=HYPERLINK("["&FileName&"]"&SheetName&"!C5","點我")