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

[µo°Ý] °}¦C¿z¿ï°ÝÃD(¤w¸Ñ¨M)

¦^´_ 10# softsadwind
¤£¬O±À´úÀ³¸Ó¬O2010ªº»yªk

With ¤u§@ªí1
With ¤u§@ªí2
With ¤u§@ªí3
­×§ï¬õ¦r³¡¤Àª«¥ó¦WºÙ²Å¦X§Aªº¤u§@ªíª«¥ó¦WºÙ¨Ò¦p" Sheet1,Sheet2,Sheet3...

TOP

¦^´_ 10# softsadwind

§Aªºªþ¥ó¤¤ÀÉ®×À³¬O2010ª©¦s¦¨97-2003ª©
©Ò¥H¤u§@ªíªºCodeName¬O"¤u§@ªí1"ªº¦r¦ê
±Nµ{¦¡½X¤º³o¨Ç§ï¦¨¥¿½T¤u§@ªí¦WºÙ¸Õ¸Õ
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 11# GBKEE

禀§i¨â¦ì¤j¤j....¤p§Ì´ú¸Õ¦p¤U
¥ÎOffice 2003¥Dµ{¦¡¶}±Ò
­×§ï¦WºÙ
¤u§@ªí1 ¡G¦¹³B»Ý­nª«¥ó
sheet 1 ¡G«¬ºA¤£²Å¦X
sheet1(2011) ¡Gª«¥ó¤£¤ä´©¦¹ÄݩʩΤèªk

¥Î2010µ{¦¡¶}±Ò
³£¬O¥X²{¥H¤U¿ù»~°T®§

¨t²Î¿ù»~&H800700E(-2147024770) §ä¤£¨ì«ü©wªº¼Ò²Õ
½sĶ¿ù»~¡G Withª«¥óªº§ÎºA¥²¶·¬O¨Ï¥ÎªÌ¦Û­q«¬ºA¡BObject©ÎVariant¤§¤@

©Ò¥HÀ³¸Ó¬O§Ú¦w¸Ëªº2010¦³°ÝÃD...¤]´N¬O.....(®ø­µ)
¦]¬°¬O¤½¥q¹q¸£ ¤£®e©ö°µ¥ô¦óÅܧó¡A©Ò¥H...µL­­´Á¼È½w...
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

¥»©«³Ì«á¥Ñ GBKEE ©ó 2011-8-31 13:47 ½s¿è

¦^´_ 13# softsadwind
§Aªº»yªk·§©À¨S¦³«Ø¥ß
Sheets(2011)     ->¦b³o¬¡­¶Ã¯¸Ìªº²Ä2011­Ó¤u§@ªí  2011¬O¼Æ¦r  
Sheets("2011") -> ­Ó¤u§@ªí¦WºÙ "2011"¬O¦r¦ê
Sheet1.Sheet2.Sheet3.... ¬O¤u§@ªíªºCodeName -> VBA¤¤¤u§@ªíªºª«¥ó¦WºÙ

TOP

        ÀR«ä¦Û¦b : ·O´d¨S¦³¼Ä¤H¡A´¼¼z¤£°_·Ð´o¡C
ªð¦^¦Cªí ¤W¤@¥DÃD