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

[µo°Ý] ¦V¤U©ì¦²¡AÀx¦s®æ¤£·|¦Û°Ê§ïÅÜ°Ñ·Ó­È

¦^´_ 1# t8899

INDIRECT¨ç¼Æ°Ñ·Ó¥~³¡ÀɮסA¸ÓÀÉ®×¥²¶·¬°¶}±Òª¬ºA¤è¥i°Ñ·Ó
§A¤½¦¡¤¤ªºaa46¬OÀx¦s®æ°Ñ·Ó©Î¬O¤å¦r©O?
­Y¬°Àx¦s®æ°Ñ·Ó¤½¦¡¦p¤U
=INDIRECT("'V:\program\supertsc\["&aa46&".xls]She5555555555555et6'!$H$2")
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 3# t8899
­º¥ý§A­n·d²M·¡©Ò¿×¥~³¡°Ñ·Ó³sµ²
·í¤½¦¡ªº°Ñ·Ó¡A·|«ü¦V¥»¨­¤u§@ªí¥H¥~ªºÀx¦s®æ´N¬O¥~³¡°Ñ·Ó³sµ²
³o¬O¥H¤½¦¡ª½±µ¼¶¼g°Ñ·Ó¦ì§}
¨Ò¦p:
='D:\EXCEL\[1020314.xls]Sheet1'!A1
³o¼Ë¬O¤@­Ó§¹¾ã¸ô®|°Ñ·Ó
­Y±N¦¹°Ñ·Ó¦r¦ê¨ä¤¤¬Y³¡¥÷¨ú¥N¡A¦p¨ä¤¤ÀɦW³¡¤À1020314¥HÀx¦s®æ¤º®e¨ú¥N
='D:\EXCEL\[&AA46&.xls]Sheet1'!A1
ÁöµM¤£·|²£¥Í¿ù»~°T®§¡A¦ý¬O·í§A¿é¤J§¹¤½¦¡®É¡AEXCEL·|­n¨D­«·s«ü©w³sµ²ÀɮסA¨Ã¥B¤£¯à»PAA46¤º®e¶i¦æ¦P¨BÅܤÆ
­n¯à°÷¥¿½T±N¸Ó¦r¦êÂà´«¦¨°Ñ·Ó¡A´N¥²¶·¨Ï¥ÎINDIRECT¨ç¼Æ
=INDIRECT("'D:\EXCEL\["&AA46&".xls]Sheet1'!A1")
¦ý¬O¡AINDIRECT¨ç¼Æªº¨Ï¥Î¥²¶·¬O¥~³¡³sµ²ÀÉ®×¥²¶·¬°¶}±Òª¬ºA
©Ò¥H§A­n¦b°Ñ·Ó¸ô®|¤¤¨Ï¥ÎÅܼƬO¤£¥i¦æªº
¥i¨Ï¥Î¦r¦ê¹Bºâ¼g¤J¤½¦¡ªº¦r¦ê
µM«á¥Î¿ï¾Ü©Ê¶K¤W­È¡AÅܦ¨¤½¦¡¦r¦ê
¦A§Q¥Î¸ê®Æ­åªR±N¤½¦¡¦r¦êÂà´«¦¨¤½¦¡
play.gif
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

        ÀR«ä¦Û¦b : ÀR§¤±`®¦¤v¹L¡B¶¢½Í²ö½×¤H«D¡C
ªð¦^¦Cªí ¤W¤@¥DÃD