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

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

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

='V:\program\supertsc\[indirect(aa46).xls]She5555555555555et6'!$H$2
aa46 ¤£·|Åܬ°
aa47
aa48
aa49
.
.
.
.

¦^´_  t8899
­º¥ý§A­n·d²M·¡©Ò¿×¥~³¡°Ñ·Ó³sµ²
·í¤½¦¡ªº°Ñ·Ó¡A·|«ü¦V¥»¨­¤u§@ªí¥H¥~ªºÀx¦s®æ´N¬O¥~³¡°Ñ·Ó ...
Hsieh µoªí©ó 2013-3-27 08:42


ÁÂÁ±zªº«ü¾É :)

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

¥»©«³Ì«á¥Ñ t8899 ©ó 2013-3-27 05:58 ½s¿è
¦^´_  t8899

INDIRECT¨ç¼Æ°Ñ·Ó¥~³¡ÀɮסA¸ÓÀÉ®×¥²¶·¬°¶}±Òª¬ºA¤è¥i°Ñ·Ó
§A¤½¦¡¤¤ªºaa46¬OÀx¦s®æ°Ñ·Ó©Î ...
Hsieh µoªí©ó 2013-3-26 23:05


§Ú¥Ø«e¥Î ='V:\program\supertsc\[indirect(aa46).xls]She5555555555555et6'!$H$2  ¬O¥i¥Hªº¡A¦ý©ì¦²¤£·|¦Û°Ê§ïÅÜ°Ñ·Ó­È
§ï¦¨ ='V:\program\supertsc\[indirect("aa"&ROW(aA46)).xls]She5555555555555et6'!$H$2   ¥X²{#REF!
§Úªºaa46 ¬° =IF(A46="","",TEXT(INDIRECT("a"&ROW(A46)),"EMMDD"))   ===>a46¬°¤é´Á®æ¦¡
emmdd (¥i¥H©ì¦²)

­ì¥»¬O§â³o¨â­Ó¼g¦¨¤@­Ó¡A¦n¹³¤£¦æ¡A´N©î¶}

TOP

¦^´_ 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

        ÀR«ä¦Û¦b : ¡i¬O§_µo´§¤F¨}¯à¡H¡j¤H¶¡¹Ø©R¦]¬°µu¼È¡A¤~§óÅã±o¬Ã¶Q¡CÃø±o¨Ó¤@½ë¤H¶¡¡AÀ³°Ý¬O§_¬°¤H¶¡µo´§¤F¦Û¤vªº¨}¯à¡A¦Ó¤£­n¤@¨ý¨Dªø¹Ø¡C
ªð¦^¦Cªí ¤W¤@¥DÃD