VBA：通过API函数，调用计算器，模拟按键等操作

最新推荐文章于 2025-01-21 00:34:21 发布

小鸿叔

最新推荐文章于 2025-01-21 00:34:21 发布

阅读量5.9k

点赞数 3

分类专栏： VB VBA 文章标签： API 函数打开程序模拟按键

本文链接：https://blog.youkuaiyun.com/jyh_jack/article/details/84387617

版权

VB 同时被 2 个专栏收录

77 篇文章

订阅专栏

VBA

42 篇文章

订阅专栏

Public Declare Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long)
Public Declare Function FindWindow Lib "user32" Alias "FindWindowA" (ByVal lpClassName As String, ByVal lpWindowName As String) As Long
Public 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
Public Declare Function SetForegroundWindow Lib "user32" (ByVal hwnd As Long) As Long
Public Declare Function ShowWindow Lib "user32" (ByVal hwnd As Long, ByVal nCmdShow As Long) As Long
Public Declare Function SendMessage Lib "user32" Alias "SendMessageA" (ByVal hwnd As Long, ByVal wMsg As Long, ByVal wParam As Long, lParam As Any) As Long
Public Declare Function PostMessage Lib "user32" Alias "PostMessageA" (ByVal hwnd As Long, ByVal wMsg As Long, ByVal wParam As Long, ByVal lParam As Long) As Long
Public Const WM_CLOSE = &H10
Public Const WM_KEYDOWN = &H100
Public Const WM_KEYUP = &H101
Public Const WM_SETTEXT = &HC

Sub work()
    Shell "Calc.exe" '打开计算器
    hwnd = FindWindow("CalcFrame", "计算器") '查找句柄
    ShowWindow hwnd, 1 '显示窗口
    SetForegroundWindow hwnd '切换为前置活动窗口（需和上一条搭配使用）
    Sleep 1000 '休息1秒钟
    
    hwnd_txt = FindWindowEx(hwnd, 0, "CalcFrame", "")
    
    PostMessage hwnd, WM_KEYUP, 54, 0 '数字6
    Sleep 1000 '休息1秒钟
    
    PostMessage hwnd, WM_KEYUP, 189, 0 '-
    Sleep 1000 '休息1秒钟
    
    PostMessage hwnd, WM_KEYUP, 49, 0 '数字1
    Sleep 1000 '休息1秒钟
    
    PostMessage hwnd, WM_KEYUP, 187, 0 '=
    Sleep 1000 '休息1秒钟
    
    SendMessage hwnd, WM_CLOSE, 0&, 0& '关闭计算器
End Sub