Sendkeys 和 Sendmessage 使用技巧一例

Private Declare Function SendMessage Lib "user32.dll" Alias "SendMessageA" (ByVal hwnd As Long, ByVal wMsg As Long, ByVal wParam As Long, lParam As Any) As Long
Private Declare Function FindWindow Lib "user32.dll" Alias "FindWindowA" (ByVal lpClassName As String, ByVal lpWindowName As String) As Long
Private Declare Function FindWindowEx Lib "user32" Alias "FindWindowExA" (ByVal hWnd1 As Long, ByVal hWnd2 As Long, ByVal lpsz1 As String, ByVal lpsz2 As String) As Long

Function sqrx(ByVal x As Double) As String '计算平方根(比VB DOUBLE 类型精度高)
Dim temp As String, i As Long, j As Long
Shell "Calc.EXE", vbMinimizedNoFocus '运行计算器
temp = x & "y0.5="
For i = 1 To Len(temp)
SendKeys Mid(temp, i, 1), True '向计算器顺序发送按键消息X (X^Y) 0.5=
Next
temp = String(64, Chr(0))
i = FindWindow(vbNullString, "计算器") '窗口句柄
j = FindWindowEx(i, ByVal 0&, "Edit", vbNullString) '编辑框句柄
SendMessage j, &HD, Len(temp), ByVal temp '发送编辑框文本至temp
SendKeys "%{F4}", True '调用ALT+F4关闭计算器窗口
sqrx = temp
End Function

Private Sub Command1_Click()
Dim i As Integer
For i = 17 To 24
Debug.Print "sqrx(" & i & ")=" & sqrx(i)
Next
End Sub

 

返回:
sqrx(17)=4.1231056256176605498214098559741                              
sqrx(18)=4.2426406871192851464050661726291                              
sqrx(19)=4.3588989435406735522369819838596                              
sqrx(20)=4.4721359549995793928183473374626                              
sqrx(21)=4.582575694955840006588047193728                               
sqrx(22)=4.6904157598234295545656301135445                              
sqrx(23)=4.7958315233127195415974380641627                              
sqrx(24)=4.8989794855663561963945681494118                              

 

可以使用 VBA 中的 Win32 API 函数 `FindWindow` 和 `SendMessage` 来控制 Edge 浏览器。 首先,你需要知道 Edge 浏览器的窗口类名和窗口标题。可以使用 Spy++ 工具获取这些信息。假设 Edge 浏览器的窗口类名为 "MicrosoftEdgeWindowClass",窗口标题为 "Microsoft Edge"。 接下来,按照以下步骤来使用 VBA 控制 Edge 浏览器: 1. 在 VBA 代码中声明 Win32 API 函数: ```vb Private Declare PtrSafe Function FindWindow Lib "user32" _ Alias "FindWindowA" (ByVal lpClassName As String, _ ByVal lpWindowName As String) As LongPtr Private Declare PtrSafe Function SendMessage Lib "user32" _ Alias "SendMessageA" (ByVal hWnd As LongPtr, ByVal wMsg As Long, _ ByVal wParam As LongPtr, lParam As Any) As LongPtr ``` 2. 使用 `FindWindow` 函数查找 Edge 浏览器的窗口句柄: ```vb Dim hwndEdge As LongPtr hwndEdge = FindWindow("MicrosoftEdgeWindowClass", "Microsoft Edge") If hwndEdge = 0 Then MsgBox "Edge browser is not running!" Exit Sub End If ``` 3. 使用 `SendMessage` 函数发送消息给 Edge 浏览器窗口: ```vb Const WM_KEYDOWN As Long = &H100 Const WM_KEYUP As Long = &H101 Dim key As Long key = Asc("A") ' 发送 A 键 SendMessage hwndEdge, WM_KEYDOWN, key, ByVal 0& SendMessage hwndEdge, WM_KEYUP, key, ByVal 0& ``` 这个例子中,我们发送了一个 "A" 键给 Edge 浏览器。你可以通过修改 `key` 变量的值来发送不同的按键。注意,`SendMessage` 函数在发送消息时需要指定不同的消息码,如 `WM_KEYDOWN` 和 `WM_KEYUP`。 希望能对你有所帮助!
评论 2
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值