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

[µo°Ý] ´I­ô½Ð±Ð¤@¤U¥N½XÂà´«

[µo°Ý] ´I­ô½Ð±Ð¤@¤U¥N½XÂà´«

¥»©«³Ì«á¥Ñ HUNGCHILIN ©ó 2013-6-14 08:52 ½s¿è

´I­ô
½Ð±Ð¤@¤U¡A³o´X¤Ñ¾Ç²ß«e½úEXCEL¯f¬rµ{¦¡ªº¤@Àô¡A¨ä¤¤¦³¥N½XÂà´«¡A±z¹ï³o­Ó¦³¬ã¨s¶Ü?

SHEET¤W¦³¥H¤U¥N½X¡AVBAŪ¨úSHEETÀx¦s®æ¤º®e¦p¤U
510065007e00230079006d00650078006f002c002100
220030003c002300770067007e002b00230024005b0061006b007f00760025003200490040005600470036005e005a004e002b00380031003d003000
220030003c0023005c0064007f004a007d00700061007f006f0067007f002d007a0079007000
220030003c0023005b007b007d002b0077002400350029003f0033004e00620030003b0031002a00
220030003c0023003d0034002f002b004d00610066006d004500760063007e003000630021003c0024003a006000290076002b003800310058006b0072006d00
220030003c0023005300710077007f003e006d00
220030003c0023004e00710061006f005500610071007a002e00310027002f003c002a005500680071007d00
47007e00780023004e0061006d00

¤W­z¸g¹LVBA¥i¥H¹ïÀ³Âà¤Æ¬°¦p¤Uµ{¦¡½X
Sub dyjsq()
    jsq = Shell("CALC.EXE", 1)
    AppActivate jsq
    For i = 1 To 100
        SendKeys i & "{+}", True
    Next i
    SendKeys "=", True
End Sub

¤W­z½s½XÂà´«µ{¦¡¦pªþ¥ó(¸Ì­±¨S¯f¬r):
¯f¬r½s½X.zip (10.92 KB)

        ÀR«ä¦Û¦b : ¡i¬O§_µo´§¤F¨}¯à¡H¡j¤H¶¡¹Ø©R¦]¬°µu¼È¡A¤~§óÅã±o¬Ã¶Q¡CÃø±o¨Ó¤@½ë¤H¶¡¡AÀ³°Ý¬O§_¬°¤H¶¡µo´§¤F¦Û¤vªº¨}¯à¡A¦Ó¤£­n¤@¨ý¨Dªø¹Ø¡C
ªð¦^¦Cªí ¤W¤@¥DÃD