Private Declare Function SetCursorPos Lib "user32" (ByVal X As Long, ByVal Y As Long) As Long
Private Sub Command1_Click()'将鼠标移动到屏幕上(500,500)的点
SetCursorPos 500, 500
end sub
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)
Private Const MOUSEEVENTF_LEFTDOWN = &H2
Private Const MOUSEEVENTF_LEFTUP = &H4
Private Sub Command1_Click()'在鼠标所在的地方左键单击一次
mouse_event MOUSEEVENTF_LEFTDOWN, 0, 0, 0, 0
mouse_event MOUSEEVENTF_LEFTUP, 0, 0, 0, 0
End Sub
结帖。
只能提供想法:
For Each In Excel.Cells
SendMessage Target, Number …
……
Next
没实测,
怎麽以FindWindowEx取得目标edit或是其他控制项,
送什麽Msg与怎麽取得对方产生的结果做处理…
这都得靠你自己探索,
在这里谈兵是谈不出结果的。