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

[µo°Ý] ¦³Ãöfieldinfo ¨Ï¥Î¤Þ¼Æ ¤@°Ý

[µo°Ý] ¦³Ãöfieldinfo ¨Ï¥Î¤Þ¼Æ ¤@°Ý

½Ð°Ý¤@¤U..
¸ê®ÆÅÜ´«®æ¦¡..
§Ú¤â¤Wªº¸ê®Æ¥u¦³..  
1  ¤@¯ë®æ¦¡
2  ¤å¦r®æ¦¡
3  ¤ë¤é¦~®æ¦¡ªº¤é´Á
5  ¦~¤ë¤é®æ¦¡ªº¤é´Á
9  ²¤¹L¤£Åª¨ú

·Q½Ð±Ð¤@¤U¨ä¥Lªº®æ¦¡.. ¦p: ¼Æ¦r... À³¸Ó¬O¤°»ò number©O...
¥ýÁÂÁ¦U¦ì¤j¤j¦^ÂÐ!!!

¦³©f¦³¨â¤j°ÝÃD¤£À´«ç³B²z...  ·QÂà¤å¦r¤SÂण¦¨.... ¿ï¾Ürange¤S¥X¿ù¤F...

·Q½Ð±Ð¦U¦ì¤j¤jÀ°§U¸Ñµª...><


½Ð°Ý¤@¤U..
¸ê®ÆÅÜ´«®æ¦¡..
§Ú¤â¤Wªº¸ê®Æ¥u¦³..  
1  ¤@¯ë®æ¦¡
2  ¤å¦r®æ¦¡
3  ¤ë¤é¦~®æ¦¡ªº¤é´Á
5  ...
jomeow µoªí©ó 2015-1-23 11:59

QUESTION.rar (490.95 KB)

TOP

¦n¹³¬O¦]¬°§A³]©w StartRow:=11

©Ò¥HŪ¶i¨Ó®É ¸ê®Æ¦ì¸m·|§ïÅÜ
·N§Y­ìÀɮתº A11 ·|Åܦ¨ A1

.Sheets("À³¦¬¹L±b«e®Ö¹ï³øªí").Range("A11 : o1500")   §ï¦¨
.Sheets("À³¦¬¹L±b«e®Ö¹ï³øªí").Range("A1 : o1500")   ´N·|¦³¸ê®Æ¤F

TOP

¦n¹³¬O¦]¬°§A³]©w StartRow:=11

©Ò¥HŪ¶i¨Ó®É ¸ê®Æ¦ì¸m·|§ïÅÜ
·N§Y­ìÀɮתº A11 ·|Åܦ¨ A1

.Sheets( ...
bobomi µoªí©ó 2015-1-23 14:03


³o¼Ëªº¸Ü.. §Ú¦A¸Õ¸Õ¬Ý..
½Ð°Ý¥t¤@°ÝÃD... Âà¤å¦r¤SÂण¦¨... À³¥i¥H«ç¼Ë¸Ñ¨M©O...

TOP

¥»©«³Ì«á¥Ñ bobomi ©ó 2015-1-23 16:15 ½s¿è
³o¼Ëªº¸Ü.. §Ú¦A¸Õ¸Õ¬Ý..
½Ð°Ý¥t¤@°ÝÃD... Âà¤å¦r¤SÂण¦¨... À³¥i¥H«ç¼Ë¸Ñ¨M©O...
jomeow µoªí©ó 2015-1-23 15:44



°ÝÃD¥X²{¤F.. Âण¦¨¤å¦r
1/1/9010
2/1/2006
2/1/2026

§A­n¸ÑÄÀ¤@¤U °ÝÃD¥X²{¤F.. Âण¦¨¤å¦r ¬O«ü¤°»ò
§Ú¬Ý¤£À´§A»¡ªº  

©ÎªÌ¥ý¸Õ¸Õ
·Æ¹«ÂI¿ï¨º­Ó¦³°ÝÃDªºÀx¦s®æ -> ·Æ¹«¥kÁä¥s¥X¥\¯à¿ï³æ ->  Àx¦s®æ®æ¦¡ -> ¿ï¾Ü G/³q¥Î ©Î ¿ï¾Ü ¤å¦r , ¬Ý¬Ý¯à¤£¯àÂন¤å¦r

TOP

¥»©«³Ì«á¥Ñ jomeow ©ó 2015-1-23 16:54 ½s¿è
°ÝÃD¥X²{¤F.. Âण¦¨¤å¦r
1/1/9010
2/1/2006
2/1/2026

§A­n¸ÑÄÀ¤@¤U °ÝÃD¥X²{¤F.. Âण¦¨¤å¦r  ...
bobomi µoªí©ó 2015-1-23 16:09



§A¬Ý¬Ý§Úªºfile´N·|©ú¥Õ¤F..
¤W¥b¬q¬O¥¿½Tªº«È¤á½s¸¹...  À³¬O:  04-0015
¤U¥b¬q¬O¥Î³o¨ÇcodeÂà¥X¨Óªº.. ´NÅܦ¨: 1/1/1900 ¬O¤£¹ïªº...
«È¤á½s¸¹ÅܤF´N¤£¦æ¤F..


§A»¡ªº¤èªk§Ú¦­´N¸Õ¹L¤F.. ¬OÂà´«¥X¨Ó®Éµo¥Íªº°ÝÃD...

TOP

¦^´_ 6# jomeow
FieldInfo:=Array(Array(1, 1), Array(2, 4), Array( 3, 1), Array(4, 1), Array(5, 1), Array(6, 2))
ªí¹F¤£²M¡BÃD·N¤£©ú½T¡B¨SªþÀɮ׮榡¡B¨S¦³°Q½×°ÝÃDªººA«×~~~~~~¥H¤W·R²ö¯à§U¡C

TOP

¦^´_  jomeow
FieldInfo:=Array(Array(1, 1), Array(2, 4), Array( 3, 1), Array(4, 1), Array(5, 1), Ar ...
stillfish00 µoªí©ó 2015-1-23 17:49


ÁÂÁ§A§r.. ³o­Ó°ÝÃD¤w¸Ñ¨M°Õ... ¦¨¥\¤F..
·Q¦h°Ý¤@¤U.. ¦pªG¸ê®Æ®w¯uªº¦³50¦æ.. ­nÂà´«ªº¸ê®Æ®æ¦¡¬O²Ä30¦æ.. ¨º¥i¥H«ç¼Ë³B²z©O?

TOP

        ÀR«ä¦Û¦b : ¤H¥Í¤£¤@©w²y²y¬O¦n²y¡A¦ý¬O¦³¾ú½mªº±j¥´ªÌ¡AÀH®É³£¥i¥H´§´Î¡C
ªð¦^¦Cªí ¤W¤@¥DÃD