- ©«¤l
- 519
- ¥DÃD
- 54
- ºëµØ
- 0
- ¿n¤À
- 595
- ÂI¦W
- 259
- §@·~¨t²Î
- win 10
- ³nÅ骩¥»
- []
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2013-3-19
- ³Ì«áµn¿ý
- 2024-11-27
|
¦^´_ 8# fei6999
©Ó±µ 5# ¤Î 7#
Private Declare Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long)
Private Declare Function SetCursorPos Lib "user32" (ByVal x As Long, ByVal y As Long) As Long
Private Declare Sub mouse_event Lib "user32" (ByVal dwFlags As Long, ByVal dx As Long, ByVal dy As Long, ByVal cButtons As Long, ByVal dwExtraInfo As Long)
Sub §Þ³N½u¹Ï_ÓªÑÅã¥Ü()
Dim stockNo$
stockNo = "3552"
Sleep (100)
AppActivate "[6000] §Þ³N½u¹Ï" 'Focus on this window
Sleep (1000)
''½T«OÁä½L¬°^¼Æ¿é¤Jªk
If IMEStatus = 1 Then
SendKeys "+", True 'Åܧó¿é¤Jªk«öÁä
End If
SendKeys "2" 'AppAtivate "ªÑ²¼¥N¸¹¡B¦WºÙ©Î¥\¯à¥N½X" µøµ¡
SendKeys "{BS}" ': Sleep (100)
SendKeys stockNo: Sleep (1000)
SendKeys "{ENTER}"
SendKeys "{NUMLOCK}": Sleep (500)
End Sub
'¦bÂIª÷ÆF¬Ý¹Ï³nÅé ªº "[6000]§Þ³N½u¹Ï" ÂI«ö Excel¹Ï¥Ü
'¶×¥X ½u¹Ï¸ê®Æ
'===========================================
Sub §Þ³N½u¹Ï¶×¥X_Click()
AppActivate "[6000] §Þ³N½u¹Ï"
Sleep 1000
µøµ¡³Ì¤j¤Æ
SetCursorPos 1845, 41 'Excel¹Ï¥Ü ªºÂI«ö¦ì¸m®y¼Ð¡A AutoIt ªº¶q´úÂI (1476,33) * Åã¥Ü¿¼Æ 125%
Sleep 1000
MouseLeft_Click
Sleep 2500
SendKeys "% R" 'µøµ¡ÁÙì
Sleep (500)
SendKeys "{NUMLOCK}"
End Sub
Sub µøµ¡³Ì¤j¤Æ()
AppActivate "[6000] §Þ³N½u¹Ï"
SendKeys "% X", True
SendKeys "{NUMLOCK}"
End Sub
Sub MouseLeft_Click()
mouse_event 2, 0, 0, 0, 0 'Key down
Sleep (50)
mouse_event 4, 0, 0, 0, 0 'Key up
Sleep (50)
End Sub
¥H¤W¡A¥i¥HÅܧóªÑ²¼¥N¸¹ ¨Ã ±N½u¹Ï¸ê®Æ¶×¥X¨ì EXCEL ÀÉ
¤£¹L¡A¦b¦hÅã¥Ü¾¹®É´N¤£ª¾n¦p¦ó³B³B²z¤F!!!! (°²³] [6000] §Þ³N½u¹Ï" ¬OÅã¥Ü¦b²Ä2ÓÅã¥Ü¾¹) |
|