ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] ½Ð°Ý¦³¨S¦³¦Û°Ê«Ø¥ß¯S©w³sµ²¤u§@ªíªº¤èªk?

[µo°Ý] ½Ð°Ý¦³¨S¦³¦Û°Ê«Ø¥ß¯S©w³sµ²¤u§@ªíªº¤èªk?

§Úªº¤@­Ó°ò¥»¤u§@ªí¤º¥]§t¦WºÙ©M©ÒÄÝÃþ§O
¨Ò¦p¡G¦WºÙ¥Ò¦P¾Ç¡AÃþ§O¥Ò²Õ
¥t¥~¦A¼W¥[¤@­Ó¦WºÙ¬°¥Ò¦P¾Çªº¤u§@ªíµM«á©M¦WºÙ¥Ò¦P¾Ç³sµ²ªº
(«ö¤F¥Ò¦P¾Ç¥i¥Hª½±µ¤Á¨ì¥Ò¦P¾Ç¤u§@ªí)

¥i¬O¦pªG¦³«Ü¦h­Ó¦P¾Ç³o¼Ë¤@­Ó¤@­Ó«ö³sµ²·|¥Î«Ü¤[
¦³¨S¦³¤°»ò¤èªk¥i¥H¥´¤F¤@¨Ç¦WºÙ´N·s¼W³o¨Ç³sµ²¦WºÙªº¤u§@ªí?

¦^´_ 1# jck201206


    ¤u§@ªíªº¯Á¤Þ·j´M
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

·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
...

TOP

¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¤Ñ°Ú~§Ú²×©ó§¹¦¨¤F~(Åxªá)¡AÁÂÁ¶W¯Åª©¥D¡A±z¤D¯«¤H¤]~

TOP

        ÀR«ä¦Û¦b : §g¤l¦p¤ô¡AÀH¤è´N¶ê¡AµL³B¤£¦Û¦b¡C
ªð¦^¦Cªí ¤W¤@¥DÃD