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

[µo°Ý] ¯à§_·j´M¤u§@ªíªº¦WºÙ

¦^´_ 3# et5323


­è­è±N±zªº¤½¦¡®M¥Î¦b§Ú¦Û¤vªºÀɮ׸̡Aµ²ªGµo²{¤@­Ó«Ü¤jªº°ÝÃD¡A¨º´N¬O¤u§@ªí¦WºÙ¬°¤¤¤åªº¡A¥þ³¡³£·|§e²{¡­NAME¡H­C¡A³o¤U¤l¥i«ç»ò¿ì¤~¦n§r¡H

TOP

­n¬Ý©w¸q¦WºÙ
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 12# Hsieh


±z¦n¤H´N°µ¨ì©³¡A½ç±Ð¦p¦ó©w¸q¦WºÙ§a¡I·P®¦±z¡I

TOP

¦^´_ 13# onegirl0204
´¡¤J/©w¸q/¦WºÙ
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 14# Hsieh


¯u¬O¤Ó·PÁ±zªº¤j®¦¤j¼w¤F¡I§Úªº°ÝÃD§¹¥þ¸Ñ¨M¡A¥H«á¦A¤]¤£¥Î¤@­Ó¤@­Ó¥Î¶W³sµ²¤F¡I
¥u¬O¦³­Ó¤p°ÝÃD·Q¦A½Ð±Ð¤@¤U¡A¦WºÙ©w¸q¤¤FIND«á­±ªº"J"¬O¤°»ò·N«ä§r¡HÁÙ¦³T(NOW())¬O¤°»ò§@¥Î¡H³Â·Ð±z¦A½ç±Ð¡AÁÂÁ¡I

TOP

¦^´_ 3# et5323

½Ð°Ý¡ã
¢°¡D¥Ñ©ó¤u§@ªí¼Æ¶q¦h¡A­Y¬O¥ÑA¡®B¨âÄæ¨Ì§Ç±Æ¤U¥h·|«Üªø¡A·Q§ï¬°¥ÑA¢Ð¨âÄæ¦V¥kµo®i¡A¥ç§Y¢Ï¢°¡ã¢Ð¢±¢¯¬°¤u§@ªí¢°¡ã¢±¢¯¡A¢Ñ¢°¡ã¢Ò¢±¢¯¬°¤u§@ªí¢±¢°¡ã¢³¢¯¡A¢Ó¢°¡ã¢Ô¢±¢¯¬°¤u§@ªí¢³¢°¡ã¢µ¢¯¡D¡D¡D¡D¡D¡D¤½¦¡¤£ª¾¸Ó¦p¦ó­×§ï¡A½Ð½ç±Ð¡ãÁÂÁ¡I
¢±¡D=COUNTA(sht)&T(NOW())¡ã¡ã­Y¬Ù²¤&T(NOW()¡Aµo²{§Ú¥Xªº¼Æ¦r¤´¬°¢²¡A¤£ª¾&T(NOW(¡^¦b¦¹¦³¦ó¯S®í·N¸q¡H

TOP

¥»©«³Ì«á¥Ñ et5323 ©ó 2010-10-10 12:55 ½s¿è

1.
a. GET.WORKBOOK(1) ±o¨ìªº¬O: [¤u§@ï¦W]¤u§@ªí¦W 这Ïú§Î¦¡ªº¦r²Å¦ê数组,¦p:
[Book1.xls]Sheet1
[Book1.xls]Sheet2
...
b. MID(GET.WORKBOOK(1),FIND("]",GET.WORKBOOK(1))+1,100)±o¨ìªº¬O:¤u§@ªí¦W 这Ïú§Î¦¡ªº¦r²Å¦ê数组,¦p:
Sheet1
Sheet2
...;
c. ±o¨ì¤u§@ªí¦W数组¦Z,´N­n¥ÎIndex¨ç数来¨ú¥X单个ªº¤¸¯À,这个¬Ý¤UIndex¨ç数ªº帮§U:
Row(A1)ªð¦^1,Index(sht,Row(A1))ªð¦^"Shtee1",Row(A2)ªð¦^2,Index(sht,Row(A2))ªð¦^"Shtee2"...
Column(A1)ªð¦^1,Index(sht,Column(A1))ªð¦^"Shtee1",Column(B1)ªð¦^2,Index(sht,Column(B1))ªð¦^"Shtee2"...
³Ñ¤Uªº´N该§A写¤F¡C

2.
T(NOW())ªº¥\¯àªñ¦ü«ö"F9"键­«·s运ºâ¤@¹M©Ò¦³¤å档,¸Ñ决§»ªí¨ç数ªº"©ö¥¢©Ê".

TOP

¦^´_ 17# et5323


·PÁ±z¸Ô²Óªº¸Ñ»¡±Ð¾Ç¤Îµ¹§Úªº®a®x§@·~¡A¬Ý¼Ë¤l§Ú±o§V¤O§ä¸ê®Æ¬ãŪ¡A¤~¯à§¹¦¨§@·~Åo¡I

TOP

§Ú¤]·Q¨Ó¾Ç²ß¬Ý¬Ý,¥¿¦n»Ý­n¨Ï¥Î°Ú!

TOP

¥Î§»ªí¨ç¼Æ©w¸q¤F¦WºÙ¡Gsht
et5323 µoªí©ó 2010-10-6 20:52


¶W¦n¥Î!
·PÁÂ!

TOP

        ÀR«ä¦Û¦b : ¯¸¦b¥b¸ô¡A¤ñ¨«¨ì¥Ø¼Ð§ó¨¯­W¡C
ªð¦^¦Cªí ¤W¤@¥DÃD