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

[µo°Ý] ¦p¦ó¼¶¼g¨âÄæ¦ì¸ê®Æ¦P®É­«½Æªº¸õµ¡´£¿ô?(¤w¸Ñ¨M,GBKEE¤j, oobird¤j)

¦^´_ 1# av8d
­Y¬O·Q¥HÀx¦s®æ³¡¤À¤º®e¨Ó¤ñ¹ïªº¸Ü,
¥i¯à©Ê½d³ò¤Ó¤j¨Ã¥B¤]¤£®e©ö±o¥X¥¿½Tªº¤ñ¹ïµ²ªG,
¨Ò¦p "¤¤¬î¸`¬¡°Ê" ´N¦³©³¤U³o¨Ç¥i¯àªºÃöÁä­È»Ý­n§@¤ñ¹ï,
¤¤¬î¸`¬¡°Ê, ¤¤¬î¸`¬¡, ¤¤¬î¸`, ¤¤¬î, ¤¤
¬î¸`¬¡°Ê, ¬î¸`¬¡, ¬î¸`, ¬î
¸`¬¡°Ê, ¸`¬¡, ¸`
¬¡°Ê, °Ê

·íµM, ­Y¬O§Aªº¨Ò¤l¥i¥HÁY¤p½d³ò,(¨Ò¦p¥u»Ý­n¤ñ¹ï©T©wªº´X­Ó¦p ¬¡°Ê»P¦aÂI...µ¥µ¥ÃöÁä¦r)
¤S©ÎªÌ¯à±N "ºÝ¤È¸`¬¡°Ê" »P "¤¤¬î¸`¬¡°Ê" ³o±Ô­z¤å¦r¦ê©î¶}©ñ¦b¨â­ÓÀx¦s®æ¤º,
Åܦ¨ "ºÝ¤È¸`", "¬¡°Ê", "¤¤¬î¸`", "¬¡°Ê" ³o¼Ë´N®e©ö¼g¤F.

¼È®É§Ú¯à·Q¨ìªº´N¬O§Q¥Î Dictionary ¨Ó¹ê²{,
¤è«Kªº¸Ü¬O§_¥i¥H¥ý¤j­P¤WÁY¤p¤@¤U»Ý­n¤ñ¹ïªº½d³ò.

TOP

¥»©«³Ì«á¥Ñ luhpro ©ó 2011-10-8 08:31 ½s¿è

¦^´_ 3# av8d
¨âÄæ¸ê®Æ­«½Æ®É¸õµ¡´£¿ô-Ans.zip (15.15 KB)

µù :
1. ­Y³æ¯Â­×§ï¤w¦³¸ê®ÆªºÀx¦s®æ¤º®e¤´¥i¥¿±`§ì¨ú¤Î¤ñ¹ï­«½Æ¸ê®Æ
2. ²§°Ê(§t·s¼W)¬YÀx¦s®æ¤º®e«á·|§ì¨ú¥þ³¡»P¤§¬Û¦P¸ê®ÆªºÀx¦s®æ, ¨Ã±N¨ä©³¦â³]¬°¶À¦â¥H¤è«K¿ëÃÑ.
3. ¤W­z³]©wªº©³¦â©ó¦A¦¸§ì¨ú(§Y¸Ó¨âÄ榳²§°Ê)®É, ·|¥ý²M°£©³¦â«á¦A¤ñ¹ï¸ê®Æ.
4. ¤£­­©w¨âÄæ¬Ò¶·¦³¸ê®Æ, ¥u­n¥ô¤@Ä榳¸ê®Æ´N¥i¥H§ì¨ú¤Î¤ñ¹ï¤º®e.
5. Debug ®É, ­Y¦³ Reset °Ê§@(©Îµo¥Í¿ù»~¾É­P²×¤îµ{¦¡®É)¥²¶·¥ý°õ¦æ Workbook_Open «á¤~¯à¦³¥¿±`ªº°Ê§@.

TOP

¦^´_ 6# av8d
rTar.AddComment "" ®Éµo¥Í "À³¥Îµ{¦¡©Îª«¥ó¤W©w¸qªº¿ù»~"...
³oÀ³¸Ó¬Oµo¥Í¿ù»~·í®É¸Ó rTar Àx¦s®æ¤w¸g¦³µù¸Ñ¤F,
¦ý³o®É«o­n·s¼Wµù¸Ñ¦Ó³y¦¨ªº¿ù»~.

¤£¹L«e­±¤w¸g¦³ On Error GoTo ErrorHandler ¤F,
©Ò¥H²z½×¤WÀ³¸Ó·|³Q "¿ù»~³B²zµ{§Ç" ¶¶§Q³B²z±¼¤~¬O,
¤£ª¾§A¬O«ç»ò¼Ëªº¾Þ§@¶¶§Ç¤Î¿é¤J¤°»ò¸ê®Æ¦Ó³y¦¨ªº¿ù»~.

§A¥i¸ÕµÛ³æ¨B°õ¦æ¬Ý¬Ýµ{¦¡¦³¨S¦³¸õ¨ì ErrorHandler °Ï°õ¦æ¿ù»~³B²z,
¤S°õ¦æ¨ì¸Ó°Ï¤¤®É¦b "§Y®É¹Bºâ" µøµ¡¤º¥´¤J ?Err.Number «ö Enter Áä,
¬Ý¬Ý Err.Number ¬O§_¬° 1004 ¤S©ÎªÌ¬O¨ä¥Lªº¼Æ¦r©O?

TOP

        ÀR«ä¦Û¦b : ¯u¥¿ªº·R¤ß¡A¬O·ÓÅU¦n¦Û¤vªº³oÁû¤ß¡C
ªð¦^¦Cªí ¤W¤@¥DÃD