- ©«¤l
- 3
- ¥DÃD
- 1
- ºëµØ
- 0
- ¿n¤À
- 9
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- office2007
- ¾\ŪÅv
- 10
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2012-6-8
- ³Ì«áµn¿ý
- 2012-6-18
|
·PÁ¶W¯Åª©¥D´£¥ÜÃöÁä¦r¤u§@ªí"¯Á¤Þ"·j´M¡A§Ú¤~¯à¬d¥X§ó¦h¸ê®Æ¡C
®Ú¾Ú³o´X¤Ñªº¾Þ§@¡A¤@¶}©l§Ú¥Î=HYPERLINK("[text.xlsx]¥Ò¦P¾Ç!B2","¥Ò¦P¾Ç")ªº¤½¦¡¡A
©Ò¥H¦b³o°ò¥»¤u§@ªíª½±µÂI¿ï¥Ò¦P¾Ç´N·|¸õ¨ì¥Ò¦P¾Ç¤u§@ªí¡A¥u¬O¤£¯à§â¤½¦¡©Ô¤U¨Ó¶ñº¡¡A
¤@Ó¤@Ó¥´nªá«Ü¤[ªº®É¶¡¡F¥Î¤F¶W¯Åª©¥Dªº¤èªk:
B2¬O¿é¤J¥Ò¦P¾ÇB3¬O¤A¦P¾ÇB4¬O¤þ¦P¾Ç¡A
D2ªÅ¥ÕÀx¦s®æ¿é¤J¤½¦¡=HYPERLINK(MID(CELL("filename"),FIND("[",CELL("filename")),FIND("]",CELL("filename"))-FIND("[",CELL("filename"))+1) & B2 & "!A1",B2 )
±µµÛD2D3D4´N¤À§Oµ¥©óB2B3B4ªº¦WºÙ¨Ã¥i¥H³sµ²¨ì¦U¤u§@ªí
ÁöµM¥i¥H©¹¤U©Ô¶ñº¡¤½¦¡§Ö¤F«Ü¦h¡A
¦ý¬O¤£ª¾¹D«ç¼Ë¤£¥ÎD2D3D4ªÅ¥ÕÀx¦s®æ¡A´Nª½±µ¦b쥻¦³¿é¤J¦P¾Ç¦WºÙªºB2B3B4¤¤ª½±µ³sµ²¹L¥h
... |
|