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

[µo°Ý] ½Ð°Ý¥N½X¤¤¿é¤J¤½¦¡ªºªí¹F¤è¦¡

[µo°Ý] ½Ð°Ý¥N½X¤¤¿é¤J¤½¦¡ªºªí¹F¤è¦¡

¤U­±¨âºØ¤è¦¡µ²ªG¨Ì¼Ë
¥H«e§Ú³£¬O¥Î²Ä2ºØ(¥Î¿ý»s¤]¬O³oºØ)¡A¦]¬°¦b®Ñ¤W¬Ý¨ìªº´N¬O²Ä2ºØªºªí¹F¤è¦¡
°¸µM¦b¬Yºô¯¸¬Ý¨ì²Ä1ºØ³oºØ¸ò§Ú­Ì¥­±`¦bÀx¦s®æ¿é¤J¤è¦¡¤@¼Ë
­ì¥»¥H¬°²Ä1ºØ¬OµLªk¹B¦æ¡Aµ²ªG«o¬O¤@¼Ë

·Q½Ð°Ý²Ä¤@ºØºâ¥¿±`ªºªí¹F¤è¦¡¶Ü?¦³¨S¦³»Ý­nª`·Nªº¦a¤è?

   ²Ä1ºØ [j6].Resize(n, 1) = "=date(left(right($g6,11),4),left(right($g6,7),2),left(right($g6,5),2))"

   ²Ä2ºØ [j6].Resize(n, 1) = "=DATE(LEFT(RIGHT(RC7,11),4),LEFT(RIGHT(RC7,7),2),LEFT(RIGHT(RC7,5),2))"
¦r¨å¨â¦U¦r ÁÙ¯uÃø²z¸Ñ

¥»©«³Ì«á¥Ñ ­ã´£³¡ªL ©ó 2015-9-23 15:26 ½s¿è

²Ä¢°ºØ¬°¡eFormula¡f¼Ò¦¡¡G¥²¶·¦b«Ø¥ß¤½¦¡ªº¡e°_©l®æ¡f¶ñ¤½¦¡¡A¥¦¤£·|¦Û°Ê²£¥Í¡e¦ì²¾¡f°Ñ·Ó¡A
[j6] = "=date(left(right($G6,11),4),left(right($G6,7),2),left(right($G6,5),2))"¡@¡÷¡@¢Ý¢Ù
[j7] = "=date(left(right($G6,11),4),left(right($G6,7),2),left(right($G6,5),2))"¡@¡÷¡@¬Ý¤@¤U[$G6]¡@¤£·|¦Û°ÊÅܦ¨¡e$G7¡f

²Ä¢±ºØ¬°¡eFormulaR1C1¡f¼Ò¦¡¡G¥i¥H¦b¦PÄæ¥ô¤@®æ¶ñ¤½¦¡¡A¦Û°Ê¦ì²¾°Ñ·Ó¡]¿ý»s¨ú±o¡A·Ç½T©Ê³Ì¦w¥þ¡^
[j6].FormulaR1C1= "=DATE(LEFT(RIGHT(RC7,11),4),LEFT(RIGHT(RC7,7),2),LEFT(RIGHT(RC7,5),2))"
[j7].FormulaR1C1= "=DATE(LEFT(RIGHT(RC7,11),4),LEFT(RIGHT(RC7,7),2),LEFT(RIGHT(RC7,5),2))"

TOP

¦^´_ 2# ­ã´£³¡ªL


    ¤j·§À´·N«ä¡A¦pªG§Ú¨Ï¥ÎResize¤@¦¸¿é¤J¥L·|¬O¥¿½Tªº¡A¨S¦³©Ò¿×¦ì²¾°ÝÃD¶Ü
¦r¨å¨â¦U¦r ÁÙ¯uÃø²z¸Ñ

TOP

¥»©«³Ì«á¥Ñ ­ã´£³¡ªL ©ó 2015-9-23 16:02 ½s¿è

¦^´_ 3# freeffly

´«­Ó°²³]¡G
¦]¬YºØ»Ý¨D, ¥²¶·±N¸ê®Æªí©¹¤U²¾¢±¦C¡A­ì¨Ó¦b¡e¢ò¢µ¡f¤U¤½¦¡¡A²{«h¬°¡e¢ò¢·¡f¡A
³o®É¡A¥²¶·±N¤½¦¡¤å¦rªº¡e¦C°Ñ·Ó¡f¥þ³¡­×§ï¤~¤£·|¥X¿ù¡A
[j8].Resize(n ,1) = "=date(left(right($G8,11),4),left(right($G8,7),2),left(right($G8,5),2))"
¡@
¦Ó²Ä¢±ºØ«h¥u­n­×§ï¤½¦¡­º®æªº¦ì¸m§Y¥i¡G
[j8].Resize(n ,1).FormulaR1C1 = ¡¨¤£¥Î§ï¡¨
¡@
µ{¦¡½Xµø¹êªp¨ú¥Î¦X¾A§Y¥i¡A¤£¥²©ëªd¥Î­þ¤@ºØ¡A¦ýÂÔ·Vªºµ{¦¡³]­pªÌ¡A·|¸û·V­«¦Ò¼{¦Ó¤w¡ã¡ã

TOP

¦^´_ 4# ­ã´£³¡ªL

    ÁÂÁª©¥D~
    ­ì¨Ó¦p¦¹¡A¬Ý¨Ó²Ä¤@ºØÁÙ¬OºÉ¶q¤£­n¥Î¡AÁöµM¯à¤ñ¸û§Ö¼g¥X
¦r¨å¨â¦U¦r ÁÙ¯uÃø²z¸Ñ

TOP

¦^´_ 5# freeffly


¨ä¹ê¦bª©¤WÀ°ºô¤Í¸ÑÃD®É¡A§ÚÁÙ¬O·|±`¥Î²Ä¢°ºØ¡A¦]¬°¡e®e©ö¾\Ū¡f¤½¦¡ªº²[·N¡F
¡@
¦Ü©ó¹ê»Ú¨Ï¥Î®É¡A§Ú·|±N¡e¼ÐÃD¦C¡fªº²Ä¢°®æ¡e©w¸q¦WºÙ¡f¡A
¨Ò¦p¡G¼ÐÃD¦C¬°¡eA5:L5¡f¡A«h±N¡e$A$5¡f©w¸q¦WºÙ¬°¡eRngHead¡f¡A
[RngHead].cells(2, 8).FormulaR1C1="¿ý»s¤½¦¡¢°"¡@¡@¡÷¡@¢Ö¢µ¤½¦¡
[RngHead].cells(2, 10).FormulaR1C1="¿ý»s¤½¦¡¢±"¡@¡@¡÷¡@¢Ø¢µ¤½¦¡
¡ã©Î§ó¦h¤£¦P¤½¦¡¡ã

³o¼Ë¦b¡e¼ÐÃD¦C¡fªº¤W¤è¡e´¡¤J¦C¡f©Î¡e§R°£¦C¡f¡A³£¤£¶·¦A¶i¤Jµ{¦¡½X¥h­×§ï¡A¦Ó¯à¥¿±`¹B§@¡ã¡ã

TOP

¦^´_ 6# ­ã´£³¡ªL
¨âºØ®æ¦¡¤]¥i¥H¦Ò¼{¥Î Application.ConvertFormula Âà´«®@¡A³o¼Ë´N¤£¥Î¨C¦¸¿ý»s¤F
ªí¹F¤£²M¡BÃD·N¤£©ú½T¡B¨SªþÀɮ׮榡¡B¨S¦³°Q½×°ÝÃDªººA«×~~~~~~¥H¤W·R²ö¯à§U¡C

TOP

        ÀR«ä¦Û¦b : §Ú­Ì­n°µ¦nªÀ·|ªºÀô«O¡A¤]­n°µ¦n¤º¤ßªºÀô«O¡C
ªð¦^¦Cªí ¤W¤@¥DÃD