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

¦p¦ó¼È°±¥¨¶°¹B¦æ

¦p¦ó¼È°±¥¨¶°¹B¦æ

¦p¦ó¦b«ö"Ctrl"Áä1¦¸¡A¨Ó¼È°±¥¨¶°xxx¹B¦æ¡A¦A«ö¦h¦¸"Ctrl"Áä¡A¥¨¶°xxxÄ~Äò¹B¦æ?ÁÂÁ¤j¤j!

¥Î¨ìApplication.OnKey¤èªk¡A¦ý§O¥Îctrlµ¥­«­n¨t²ÎÁä¡C
°j°é¹Lµ{¤¤¥ÎDoEvents¡C

TOP

¥Î¨ìApplication.OnKey¤èªk¡A¦ý§O¥Îctrlµ¥­«­n¨t²ÎÁä¡C
°j°é¹Lµ{¤¤¥ÎDoEvents¡C
oobird µoªí©ó 2010-11-9 08:09



    ³]©w«ö"A"Áä§@°±¤î¥¨¶°¡A¤p½úªº¿ù¦b­þ¸Ì?
°±¤î.rar (14.88 KB)

TOP

¥ÎDoEvents... oobirdª©¥D¤w¸g§ó±zÁ¿¤F...
¥u¬O±zªºµ{¦¡Run¤@¦¸­nÂI®É¶¡ ©Ò¥H«ö¤U"A"­n¦Aµ¥¤@¤U~



Sub ¼ÒÀÀ«öÁä()

    Dim X As Integer
    Dim Y As Integer
    X = 90
    Y = 350
    Call SetCursorPos(X, Y)
   
    mouse_event 2, 0, 0, 0, 0
    mouse_event 4, 0, 0, 0, 0
   
      keybd_event 17, MapVirtualKey(17, 0), 0, 0
      keybd_event 67, MapVirtualKey(67, 0), 0, 0
      keybd_event 67, MapVirtualKey(67, 0), 2, 0
      keybd_event 17, MapVirtualKey(17, 0), 2, 0
      
    X = 90
    Y = 490
    Call SetCursorPos(X, Y)
    mouse_event 2, 0, 0, 0, 0
    mouse_event 4, 0, 0, 0, 0
      
    Sheets("sheet1").Cells(3, 3).Select
    ActiveSheet.Paste
    Sleep 3000
   
    DoEvents
    Application.OnKey "A", "°±¤î"

    ¼ÒÀÀ«öÁä
End Sub
­Y¬O§Ú¦^µª¡A¨Ï±zº¡·N¡A½Ð±zÅý§Úª¾¹D¡I                  
­Y¬O§Úªº¦^ÂСA±z¤´¦³¨ä¥L¨£¸Ñ¡A¤]½Ð±z¤£¶Þ«ü±Ð¡I

TOP

¥ÎDoEvents... oobirdª©¥D¤w¸g§ó±zÁ¿¤F...
¥u¬O±zªºµ{¦¡Run¤@¦¸­nÂI®É¶¡ ©Ò¥H«ö¤U"A"­n¦Aµ¥¤@¤U~



S ...
Min µoªí©ó 2010-11-9 20:29



    ·PÁª©¤j!
¦bSleepªº®É¶¡¤º¡Acommand buttom¥Î¤£¨ì¡A¦³¨S¦³¥i¦bDELAY®É¶¡¤º(¹w©wDELAY1/2¬í)¡A¥i¥Î¨ìªº?¦A¦¸·PÁÂ!

TOP

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